Possibly a stupid question, but have you tried assigning them to a real
variable and loading them straight as a real.
e.g.
var tempdate:real;
tempdate:=foxprodb.fieldbyname('date1').asfloat;
interbasedb.fieldbyname('date1').asfloat:=tempdate;
This way letting the database server sort out how it stores as apposed to
doing any formatting on it yourself ?
Of course if foxpro is storing it as a string, instead of as a tdatetime,
this won't work.
Just a thought,
Matt.
----- Original Message -----
From: "Rohit Gupta" <[EMAIL PROTECTED]>
To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]>
Sent: Friday, September 03, 2004 12:11 PM
Subject: Re: [DUG] Interbase dates
> We use yyyy/mm/dd then there is no confusion with the US format
> (or use text month names as you have just done)
>
> >
> >
> > Hi
> >
> > Wondering if anyone can shed some light on a problem i'm having with
interbase dates. I have an
> > app that pumps data from foxpro table to a new interbase db, when doing
comparsion after
> > transfering data there is a problem with some of the dates.
> > Dates that were dates within foxpro datatables are fine
> > Dates that were stored as characters in foxpro if eg 12/07/2004 end up
as 07/12/2004 but
> > 22/07/2004 transfer correctly using the same procedure, it doesn't seem
to make any difference
> > what formatting is done before inserting them into interbase, they still
come out the same.
> >
> > Cheers
> > Robert Wilson
> > IS Developer
> > Cellect and IT Wholesale
> > Ph: +64 (0) 9 415 4747
> >
> > Attention:
> > Disclaimer:
> > The information in this electronic mail message is confidential and may
be legally privileged. It is
> > intended solely for the addressee. Access to this Internet electronic
mail message by anyone else
> > is unauthorised.
> > If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or
> > omitted to be taken in reliance on it is prohibited and may be unlawful.
> > If you have received this e-mail by mistake please call the sender
immediately on 09 415 4747
> > and erase the original message and any attachments.
> > Cellular Cellnet (NZ) Ltd accepts no responsibility for any effects this
email message or
> > attachments has on the recipient network or computer system.
> >
>
> Regards
>
> Rohit
>
> ======================================================================
> CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
> PH (649) 489-2280
> FX (649) 489-2290
> email [EMAIL PROTECTED] or [EMAIL PROTECTED]
> ======================================================================
>
>
> _______________________________________________
> Delphi mailing list
> [EMAIL PROTECTED]
> http://ns3.123.co.nz/mailman/listinfo/delphi
>
>
>
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
