Try this '2004-08-04 11:22 am' also the quotes have to be correct. Janet
-----Original Message----- From: Witango [mailto:[EMAIL PROTECTED] Sent: Thursday, August 05, 2004 11:26 AM To: [EMAIL PROTECTED] Subject: Witango-Talk: Date/Time wierdness again Hello all, - My MSSQL 2000 data field is set for smalldatetime - Tango 2K Server default Time Format is 12:00 AM (example) - When I write <@CURRENTTIME FORMAT="%I:%M %p"> to SQL, it will store 11:22 AM (behaving itself) - When I try to write: '11:22 AM' directly, it stores 1/1/1900 11:22:00 AM - When I try to write '04-Aug-2004 11:22 AM' directly it stores 1/1/1900 11:22:00 AM Any clues why it's doing this to me and making my life miserable for no reason whatsoever and better still, how can I fix it. Thanks much guys. Vic ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
