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

Reply via email to