i do not insert date sql add the date to the time
----- Original Message -----
From: "Lokesh Ram" <[EMAIL PROTECTED]>
To: "Multiple recipients of list witango-talk" <[EMAIL PROTECTED]>
Sent: Friday, July 05, 2002 3:23 PM
Subject: Re: Witango-Talk: sql question
>
> use SUBSTRING(expression, start, length) function of sql before inserting
> into table
> [EMAIL PROTECTED] writes:
> >i have a problem whit en sql table i have severall field that i use as
> >time field
> >and i do caclulation whit the times
> >
> >so i want just the tiem 10:30:00 to be in the field when i insert this in
> >a sql table the field contains 1-1-1900 10:30:00
> >haw can i prevent that the date is also enterd in the field
>
> cheers
>
> M.Lokesh Ram
> office 01-8142042
> mobile 0857243836
> house 01-8741195
>
>
>
> _____________________________________________________
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> This email has been scanned for known viruses.
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
