sending time to DB

[MerlinKnight]

hello,
I am trying to send a time/date data to an access database. I notice that in the DB i get the date but not the time.
If i try to just send the time i get 12:00:00 no matter what the time is. Date will send fine if i just send it.
I am using WonderWare and sending it to another computer through the ODBC. The system use to work fine on the Windows NT computer but i upgraded to Windows XP Pro. and it stopped working correctly.
I figure it's some kind of format issue but can't figure it out. I am sending it as 1:00:00 but getting 12:00:00. When it was sent as a general data file it was 11/10/2005 1:00:00 and it use to work until the upgrade.

Thanks,
Merlin knight

 

[stephenk1973]

How are you calling the date time? Try using...

now()


Hope this helps

Stephen