Hi,

I'm trying to insert a date like this:

INSERT INTO MY_TABLE (DATEFIELD) VALUES('06/05/2004');

Now, this is in dd/mm/yyyy format, hence 6th may 2004. When I insert
it, it and then do a select in IBO Console, i see '05/06/2004'. So i
think, oh ok the DB is showing me dates in mm/dd/yyy format, no problem.

However, I go and select this date using .Net provider and I get the
date 5th Junes 2004, i.e. i has actually swapped my day and month
around and not just showing a different format.

Question: How do I get FB to understand that my dates are in
dd/mm/yyyy format and should only be so.

FYI:

Running FB 1.5, Win XP Pro, local settings set to UK time and
localisation (hence dd/mm/yyy)

Any ideas?

Thanks

Giulio