At 09:52 AM 14/05/2004, you wrote:

>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

The only way I have found to work infallibly on every system I have ever
used is to write software on the client side to convert the date into the
format

"DD-MMM-YYYY" (for example "02-JUL-2004")

This has the advantage of working with every SQL I have ever used.

Regards

Tim


[Non-text portions of this message have been removed]