Re: [GENERAL] How Can I set a non standard date format?

2007-03-03 Thread Shane Ambler
[EMAIL PROTECTED] wrote: Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I can use to_char to format the date anyway I want, b

Re: [GENERAL] How Can I set a non standard date format?

2007-03-03 Thread Joshua D. Drake
[EMAIL PROTECTED] wrote: > Hi All Esteemed Developers, > > I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 > > I want to be able to have dates returned from a query in this format > so that I can use passthrough queries from Access. I know I can use > to_char to format the date anyw

Re: [GENERAL] How Can I set a non standard date format?

2007-03-02 Thread Andrej Ricnik-Bay
On 2 Mar 2007 11:20:28 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I c

[GENERAL] How Can I set a non standard date format?

2007-03-02 Thread clark
Hi All Esteemed Developers, I have a requirement to have dates like ddmmmyyy. ie: 03MAR07 I want to be able to have dates returned from a query in this format so that I can use passthrough queries from Access. I know I can use to_char to format the date anyway I want, but this causes the column t