Please disregard last post...i have solved the issue by casting the date as dd/mmm/yyyy as opsosed to dd/mm/yyyy or mm/dd/yyyy
Robert Wilson
IS Developer
Cellect and IT Wholesale
Ph: +64 (0) 9 415 4747
| "Robert Wilson" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 02/09/2004 09:55 a.m.
|
To: "NZ Borland Developers Group - Delphi List" <[EMAIL PROTECTED]> cc: Subject: [DUG] Interbase dates |
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.
_______________________________________________
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
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.
_______________________________________________ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
