From: Kaare Rasmussen <kar@kakidata.dk>
To: Paul <paul@operamail.com>
To: pgsql-sql@postgresql.org
Subject: Re: to_date()
Date: Mon, 3 Jun 2002 18:04:56 +0200
Message-ID: <20020603160445.0901F475BC2@postgresql.org> (raw)
In-Reply-To: <20020603005347.29190.qmail@operamail.com>
References: <20020603005347.29190.qmail@operamail.com>
> Can someone explain to me why this happens?
> ======
> select to_date('2002-04-29 07:33:55.000','FXYYYY-MM-DD HH24:MM:SS.MS') as
> rebill_date; rebill_date
> -------------
> 2004-09-30
If you only want the date:
select to_date('2002-04-29 07:33:55.000','FXYYYY-MM-DD HH24:MI:SS.MS') as
rebill_date;
If you want the whole thing:
select to_timestamp('2002-04-29 07:33:55.000','FXYYYY-MM-DD HH24:MI:SS.MS')
as rebill_date;
MM is month
MI is minute
--
Kaare Rasmussen --Linux, spil,-- Tlf: 3816 2582
Kaki Data tshirts, merchandize Fax: 3816 2501
Howitzvej 75 Åben 12.00-18.00 Web: www.suse.dk
2000 Frederiksberg Lørdag 11.00-17.00 Email: kar@kakidata.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-sql@postgresql.org
Cc: kar@kakidata.dk, paul@operamail.com
Subject: Re: to_date()
In-Reply-To: <20020603160445.0901F475BC2@postgresql.org>
* 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