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
