Title: Re: Witango-Talk:  sql question
I don’t think you can prevent the date wh3en you use Datetime as a field. But when you do your calculation if you user
<@@local$mydate FORMAT:Datetime=”%H::%M:%S”> (for 24 hours clock.

on 7/5/02 9:07 AM, robert at [EMAIL PROTECTED] wrote:

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



--
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Mobile: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com

Reply via email to