In your script, you'll have to use a function to only pull out the time. I'm
only familiar with MySQL, but I've done this many times. You can find
information on Date and Time functions for here -
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
Kolene
Joe Santiago wrote:
> 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.
