Subject RE: [firebird-support] Fundamental of DATE type
Author Alan McDonald
> I have a problem here, I have inserted a lot of record into my
> table from many processes which is one of it's field is a DATE
> type. The problem is about the DD and MM formatting, I am
> inserting using this Syntax
> Insert Into TABLE (dtreceive, price, ID) values ('9/1/2003', 23000, 2);
> I mean convert the date data from a String '9/1'2003' to input
> in MM/DD/YYYY format, but a lo of the data is reversed in DD/MM/YYYY.
> I want to know how's the most efficien way to input into the
> table so I will never worry about the format sequences again.

from web applications I always convert to '23 Jun 2003' format so there's no
confusion about mm/dd or dd/mm
but from delphi I can always just use the date type data and there is no
conversion required