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
Hi
I am inserting a Time like 06:00 from my code to a Date/Time field in SQLServer7...the
value I am sending in my program is perfectly finebut...when It gets in the
database... it gets screwed up to be like 01/01/1900 06:00:00
What I need really is only the time rather than Date/Time.
Any