Subject Re: [firebird-support] Casting a Date to a Varchar inverts its format?
Author Stephen Davey
Check the Regional Settings on your computer. Look at the date format.

----- Original Message -----
From: dr_bentonquest
Sent: Friday, December 08, 2006 12:29 PM
Subject: [firebird-support] Casting a Date to a Varchar inverts its format?

Firebird 1.5.3. here.

select invoicedate from invoices


select cast(invoicedate as varchar(10)) from invoices


Date format gets inverted and I don't want this. I need to concatenate
the date field to a varchar "time" field, like this:

invoicedatetime = cast(invoicedate as varchar(10)) || invoicetime;

But the result is:

"2006-01-01 09:21"

Same result if I do this (implicit conversion):

invoicedatetime = invoicedate || invoicetime;

What I need is this:

"01-01-2006 09:21"

What am I missing here and how can I accomplish what I need?



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