Re: Store datetime field as String

Article View: borland.public.interbase.sql

Article #800

Back to borland.public.interbase.sql Previous Next

#800

From: Wayne Niddery [TeamB]
Date: Wed, 09 May 2007 14:45

17 lines
1667 bytes

Craig Cookesley wrote:
>
> That worked, except I get the date as DD-MMM-YY when I would like
> DD/MM/YY
> ie  9- MAY-20 TO 09/05/07
>
> Is this possible?

Not to my knowledge. While InterBase supports several date formats when 
writing to tables, they are always output in this single format. It is 
really up to applications to format dates into strings and dates should be 
stored in the database *as dates* instead of strings.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"True peace is not the absence of tension, but the presence of
justice."  - Martin Luther King, Jr.

Technical Details

Message-ID: <4641de99$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.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

References: <4640605c@newsgroups.borland.com> <464088c2@newsgroups.borland.com> <46412e4d@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,d8456dd5bcafd5a4
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <4640605c@newsgroups.borland.com> <464088c2@newsgroups.borland.com> <46412e4d@newsgroups.borland.com>
Subject: Re: Store datetime field as String
Date: Wed, 9 May 2007 10:45:46 -0400
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <4641de99$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1178721945 69.17.170.228 (9 May 2007 07:45:45 -0700)
Path: arc1-ca.pugleaf.net!g2news1.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

Reply to Parent Message