That is not the proper format for a date/time field.
It should be CCYYMMDDHHMMSS as a number or 'CCYY/MM/DD HH:MM:SS' as a
string.
You may not use any other format for an insert/update.
[EMAIL PROTECTED] wrote:
Hi
I am inserting a Time like 06:00 from my code to a Date/Time field in SQLServer7.
Sam, heads up!
MySQL list members don't want this = spam!
=dn
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, December 03, 2002 4:54 PM
Subject: Time&Date in SQLServer7
> Hi
>
> I am inserting a Time like 06:00 from my code to a
