From: Aarni Ruuhimäki <aarni@kymi.com>
To: pgsql-sql@postgresql.org
Cc: Gavin 'Beau' Baumanis <gavinb@eclinic.com.au>
Subject: Re: dateformat issue
Date: Thu, 10 Apr 2008 10:27:24 +0300
Message-ID: <200804101027.24977.aarni@kymi.com> (raw)
In-Reply-To: <BC2EE6A2-266A-453D-957B-3C7482CEBCF4@eclinic.com.au>
References: <8817FD2B-5B01-4E3D-9C6D-A6FF165561FB@eclinic.com.au>
<200804100917.33729.aarni@kymi.com>
<BC2EE6A2-266A-453D-957B-3C7482CEBCF4@eclinic.com.au>
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
> Syntax
>
> CreateODBCDate(date)
>
> so I pass in 2008-01-23
> and I get back
>
> {d '2008-01-23'}
>
> The weirdness for me is that it works elsewhere in the application, I
> am really stumped.
>
> -Gavin.
>
That value shouldn't work at all ... ?
<cfoutput>
#Now()# ||
#CreateODBCDate(2008-04-10)# = #CreateODBCDate(1994)#
|
#CreateODBCDate('2008-04-10')#
|
#CreateODBCDate(Now())#
|
#DateFormat(Now(), "YYYY-MM-DD")#
|
#DateFormat('2008-04-10', "YYYY-MM-DD")#
</cfoutput>
Produces:
{ts '2008-04-10 10:26:21'} || {d '1905-06-16'} = {d '1905-06-16'} | {d
'2008-04-10'} | {d '2008-04-10'} | 2008-04-10 | 2008-04-10
This is on CFMX7.
Best regards,
--
Aarni Ruuhimäki
---
Burglars usually come in through your windows.
---
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: aarni@kymi.com, gavinb@eclinic.com.au
Subject: Re: dateformat issue
In-Reply-To: <200804101027.24977.aarni@kymi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox