database:
Firebird Last release
problem:
When i insert date value into date field, then firebird change day.value with month.value. For example if i insert date value in format (dd/mm/yyyy) = 10/01/2005 , Firebirds inserts this value like 01/10/2005
all my date value are in format dd/mm/yyyy
when i insert date value using this query,
insert into TABLE_NAME(FIELD_NAME), values('10/01/2005')
then Firebird inserts this value like mm/dd/yyyy
result is:
Day = 01
Month = 10
Year = 2005
----------------
when i insert date value using this query,
insert into TABLE_NAME(FIELD_NAME), values('10.01.2005')
then Firebird inserts this value like mm/dd/yyyy
result is:
Day = 10
Month = 01
Year = 2005