Or a tdatetime for that matter ;)
----- Original Message -----
From: "Matt Comb" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; "NZ Borland Developers Group - Delphi List"
<[EMAIL PROTECTED]>
Sent: Friday, September 03, 2004 6:46 PM
Subject: Re: [DUG] Interbase dates
> 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
>
>
>
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
