|Subject||Re: [firebird-support] Casting a Date to a Varchar inverts its format?|
Check the Regional Settings on your computer. Look at the date format.
----- Original Message -----
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:
Same result if I do this (implicit conversion):
invoicedatetime = invoicedate || invoicetime;
What I need is this:
What am I missing here and how can I accomplish what I need?
[Non-text portions of this message have been removed]