On Tue, 2006-07-25 at 12:54 -0400, Chris Hoover wrote: > I know I can do a select to_date(now(),'yyyy-mm-dd') and it will > return the date. However, how do I get the time?
Casting is the better option, but the to_date format spec handles a lot more than just dates. See: http://www.postgresql.org/docs/8.1/interactive/functions-formatting.html The casting way: [EMAIL PROTECTED]> select '2006-07-25 21:24'::time; time ---------- 21:24:00 [EMAIL PROTECTED]> select '2006-07-25 21:24'::date; date ------------ 2006-07-25 The to_char way: [EMAIL PROTECTED]> select to_char(now(),'HH24:MI'); to_char --------- 10:44 Or the baroque way for your, ahem, timeless applications: [EMAIL PROTECTED]> select to_char('2006-07-25 20:24'::timestamp,'MI "minutes" past the HH24th hour'); to_char ------------------------------- 24 minutes past the 20th hour [EMAIL PROTECTED]> select to_char('2006-07-25 21:24'::timestamp,'MI "minutes" past the HH24th hour'); to_char ------------------------------- 24 minutes past the 21st hour -Reece -- Reece Hart, http://harts.net/reece/, GPG:0x25EC91A0 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
