| From: | Kaare Rasmussen <kar(at)kakidata(dot)dk> |
|---|---|
| To: | "Paul " <paul(at)operamail(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: to_date() |
| Date: | 2002-06-03 16:04:56 |
| Message-ID: | 20020603160445.0901F475BC2@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> 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(at)kakidata(dot)dk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joseph D. Barillari | 2002-06-03 18:02:55 | Re: Syntax error in plpgsql crashes backend |
| Previous Message | Andre Schubert | 2002-06-03 13:46:46 | Re: How to update |