jackie,
a date is a date is a date... it gets stored as a floating point number not
as a dd, mm, yyyy in some combo. It's an integer representing the days from
31 Dec 1899 (thereabouts) and the decimal is that fraction of the day in
seconds.
So the 19th March 2002 is not stored as 03 or 3 under your control. Your
client application is in the only control of representing that month as 03.
Just change your date settings to show MM rather than mm for the month part.

Alan
-----Original Message-----
From: jackie [mailto:jackieg@...]
Sent: Thursday, 31 October 2002 0:28
To: ib-support@yahoogroups.com
Subject: [ib-support] Date Format in IB


Hi this is my first post to this group and compared to what I have been
reading since joining several weeks ago my problem is hopefully a trivial
one. I did post this question on borland's Interbase.opensource newsgroup
but as I haven't had a response I thought I'd use this as my introduction
to
this group.

I have a date field in a table and am using a Delphi TMaskEdit field to
enable date entry in the format 19032002 but what I am finding is that the
is stored and retrieved from IB as 19/3/2002. Is there a way to change
this
so that the dates' day and month are in fact stored and retrieved in '00'
format?

Thanks for your help.

jackie....(been using IB6.0.2.0 for a little while now and while only an
beginner aspires to be a guru one day...LOL)



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]