Date converson for JDBC

[schep]

my site was just moved to MX 6.1 and the system is complaining it can't convert
the date for insertion into a SQL Server 7 "short date" field. I know JDBC
doesn't like the ODBC date format but nothing I try is accepted. Must the CF
Administrator change an attribute on the server? Thanks for any help!

[paross1]

You could use the SQL Server getdate() function instead of CF's #now()#
function, but if you really want or need to use #now()#, you might just CAST it
to a smalldatetime datatype:

INSERT INTO table (datecol)
VALUES (CAST(#now()# AS smalldatetime))

Phil