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
