Date format problem

Article View: borland.public.interbase.sql

Article #839

Back to borland.public.interbase.sql Previous Next

#839

From: AntonE
Date: Wed, 23 May 2007 19:54

8 lines
1271 bytes

I'm starting to write TCP server/client software and my client app is 
sending a SQL query as text to the server to process. Now the query involves 
a datetime so  I just use DateTimeToStr(Now) but as the regional settings 
might be different and out of my control on either side, how can I convert 
DateTime into SQL-safe string that all IB servers would accept?

Thanks
AntonE

Technical Details

Message-ID: <46549b87@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,61360681df372f16,start
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "AntonE" <antone@true.co.za>
Newsgroups: borland.public.interbase.sql
Subject: Date format problem
Date: Wed, 23 May 2007 21:54:08 +0200
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 196.34.167.131
Message-ID: <46549b87@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179949959 196.34.167.131 (23 May 2007 12:52:39 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!border2.nntp.dca.giganews.com!nntp.giganews.com!newspeer1.nwr.nac.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail