Re: Witango-Talk: sql question

[robert]

Title: Re: Witango-Talk: �sql question

ms sql 2000 i moved from access to sql ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 4:58 PM Subject: Re: Witango-Talk: sql question What databse you use ???   regards   Daniel ----- Original Message ----- From: robert To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 4:43 PM Subject: Re: Witango-Talk: sql question but i use the same table in other appication and the can`t handle text field so i need a datetime field whit only the tine in it ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 4:24 PM Subject: Re: Witango-Talk: sql question Sory, i have forget it:   For Witango it dos no mather if you calculate with a value from a Text-Field. It will be handle as number...   regards   Daniel ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 4:11 PM Subject: Re: Witango-Talk: sql question For the insert:   Define teh format what you want - if your field only accept timestamps, so change the field in a textfiled. Hope this help   Mit freundlichen Gr��en, with best regards   Daniel Richardy   ________European Witango Mainland Distributor __________   SoftDes GmbH - St. Georgener Strasse 13 - D 79111 Freiburg Web: www.softdes.de                    Mail:  [EMAIL PROTECTED] Phone: +49 - 761 - 4 555 666         Fax: +49 - 761 - 4 555 660 _________________ www.witango.net  ___________________ ----- Original Message ----- From: robert To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 3:44 PM Subject: Re: Witango-Talk: sql question in witango i can show the date how i want but is use the sametble in access xp and when i want to edit the fiels the same dat show up and calc dont work properle ----- Original Message ----- From: Dan Stein To: Multiple recipients of list witango-talk Sent: Friday, July 05, 2002 3:33 PM Subject: 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