Re: Date format problem

Article View: borland.public.interbase.sql

Article #844

Back to borland.public.interbase.sql Previous Next

#844

From: Craig Stuntz TeamB
Date: Wed, 23 May 2007 22:17

15 lines
1798 bytes

AntonE wrote:

> Will IB server always use the PC's "ShortDateFormat [space]
> ShortTimeformat" to parse Timestamp as text?

	No. Never. IB uses fixed formats which don't change with machine
locale. Delphi, OTOH, uses the current locale, which is why
DateTimeToStr can't be truested to produce something IB can read unless
you set the ShortDateFormat first.

-- 
Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
Please read and follow Borland's rules for the user of their 
  server: http://support.borland.com/entry.jspa?externalID=293

Technical Details

Message-ID: <4654bd8c$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<46549b87@newsgroups.borland.com> <4654a104@newsgroups.borland.com> <4654a791@newsgroups.borland.com> <4654b859$1@newsgroups.borland.com> <4654bab8@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,61360681df372f16
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII
From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]>
Subject: Re: Date format problem
Newsgroups: borland.public.interbase.sql
References: <46549b87@newsgroups.borland.com> <4654a104@newsgroups.borland.com> <4654a791@newsgroups.borland.com> <4654b859$1@newsgroups.borland.com> <4654bab8@newsgroups.borland.com>
Organization: Vertex Systems Corporation
User-Agent: XanaNews/1.18.1.5
X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: 24.106.104.205
Message-ID: <4654bd8c$1@newsgroups.borland.com>
Date: 23 May 2007 15:17:48 -0700
X-Trace: newsgroups.borland.com 1179958668 24.106.104.205 (23 May 2007 15:17:48 -0700)
Lines: 15
X-Authenticated-User: cstuntz
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message