Subject | how to insert DATE in a different format? |
---|---|
Author | Cey Cey |
Post date | 2005-06-30T05:57:36Z |
I'd like to insert a date into a DATE column in the dd/mm/yyyy format
but FB expects it in the mm/dd/yyyy format. (I get a "convertion error
from string '15/01/2005'" when I try the INSERT INTO TBL VALUES
('15/01/2005') statement. (TBL is a table with only one column of type
DATE).
Interestingly when I retrieve dates which were inserted in the expected
format (i.e. mm/dd/yyyy), they seem to be stored in the format I want
(i.e. IBExpert displays them in the dd/mm/yyyy format)
Anyway, I'm just curious if there is an easy way to change the format
FB accepts date values?
I'm using FB embedded 1.5.2. I'm new to FB and SQL so I'd appreciate
any help. Thanks!
but FB expects it in the mm/dd/yyyy format. (I get a "convertion error
from string '15/01/2005'" when I try the INSERT INTO TBL VALUES
('15/01/2005') statement. (TBL is a table with only one column of type
DATE).
Interestingly when I retrieve dates which were inserted in the expected
format (i.e. mm/dd/yyyy), they seem to be stored in the format I want
(i.e. IBExpert displays them in the dd/mm/yyyy format)
Anyway, I'm just curious if there is an easy way to change the format
FB accepts date values?
I'm using FB embedded 1.5.2. I'm new to FB and SQL so I'd appreciate
any help. Thanks!