Re: [SQL] dateformat issue

2008-04-10 Thread Volkan YAZICI
Hi, Gavin 'Beau' Baumanis <[EMAIL PROTECTED]> writes: > I have a question about dates, please. > > I am using Coldfusion and Postgres > I have a function that takes the ate entered in a form and converts it > into an odbc date format. > > So the string ends up being; > {d '2008-04-10'} > > Strange

Re: [SQL] dateformat issue

2008-04-10 Thread Tk421
Gavin 'Beau' Baumanis escribió: Hi Everyone, I have a question about dates, please. I am using Coldfusion and Postgres I have a function that takes the ate entered in a form and converts it into an odbc date format. So the string ends up being; {d '2008-04-10'} Strangely, the function is us

Re: [SQL] dateformat issue

2008-04-10 Thread Aarni Ruuhimäki
On Thursday 10 April 2008 09:41, Gavin 'Beau' Baumanis wrote: > Hi Aarni, > > just so you know I am using the CF built-in function, > createodbcdate > > here is the info from livedocs. > > CreateODBCDate > Description > > Returns a date in ODBC date format. > Category > > Date and time functions >

Re: [SQL] dateformat issue

2008-04-09 Thread Gavin 'Beau' Baumanis
Hi Aarni, just so you know I am using the CF built-in function, createodbcdate here is the info from livedocs. CreateODBCDate Description Returns a date in ODBC date format. Category Date and time functions Syntax CreateODBCDate(date) so I pass in 2008-01-23 and I get back {d '2008-01-23'}

Re: [SQL] dateformat issue

2008-04-09 Thread Aarni Ruuhimäki
On Thursday 10 April 2008 03:14, Gavin 'Beau' Baumanis wrote: > Hi Everyone, > > I have a question about dates, please. > > I am using Coldfusion and Postgres > I have a function that takes the ate entered in a form and converts it > into an odbc date format. > > So the string ends up being; > {d '

[SQL] dateformat issue

2008-04-09 Thread Gavin 'Beau' Baumanis
Hi Everyone, I have a question about dates, please. I am using Coldfusion and Postgres I have a function that takes the ate entered in a form and converts it into an odbc date format. So the string ends up being; {d '2008-04-10'} Strangely, the function is used throughout the application an