From: leif@danmos.dk
To: pgsql-interfaces@postgresql.org
Subject: to_date problem
Date: Thu, 15 Mar 2001 08:37:26 +0100
Message-ID: <200103150737.f2F7bQl13172@crysberg.dk> (raw)
Hello,
I have just observed the following problem:
-------------------------------------------------------------------
testdb=# select to_date('2001-3-5 10:00', 'YYYY-MM-DD HH24:MI') from dual;
to_date
------------
2001-03-10
(1 row)
testdb=# \q
[nsadmin@ljserv calendar]$ psql --version
psql (PostgreSQL) 7.1beta3
contains readline, history support
Portions Copyright (c) 1996-2000, PostgreSQL, Inc
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or use the command \copyright to see the
usage and distribution terms.
-------------------------------------------------------------------
I know that the date constant is not in the same format as the format
string, but shouldn't it be an error rather than 'just' returning a
wrong date?
Any suggestions,
Leif
(leif@danmos.dk)
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-interfaces@postgresql.org
Cc: leif@danmos.dk
Subject: Re: to_date problem
In-Reply-To: <200103150737.f2F7bQl13172@crysberg.dk>
* 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