I have a perl script using a do to insert stuff into a database. The only
problem that I am having is entering a time into a DATETIME datatype field.
When I enter it manually using the manager gui I can enter something like
'9:00 AM' but when I use my script it always enters the value as '01/01/2001
9:00 AM'. It adds that date. Any help would be appreciated. I do not have a
snippet of the code until I make it to work but I was wondering if anyone
was familiar with the DATETIME datatype for SQL server 7. Thanks.