Search Postgresql Archives

Re: Constructors for dates, times, and timestamps

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks for the pointers.  I did figure out

   'yyyy-mm-dd'::date
   'hh:mm:ss'::time

And I also came up with

   (date_column::text || ' ' || time_column::text)::timestamp

Which is too ugly for words. I appreciate the more elegant solutions posted to the list.

I'm growing to like Postgres, but I'm not sure I'll ever get over DB/2 :-)

Andy
begin:vcard
fn:Andrew T. Robinson, CISM, CISSP
n:Robinson;Andrew
org:NMI InfoSecurity Solutions
adr:;;145 Newbury Street Second Floor;Portland;ME;04101;USA
email;internet:atr@xxxxxxx
title:President
tel;work:207-780-6381 x226
tel;fax:207-780-6301
x-mozilla-html:TRUE
url:http://www.nmi.net
version:2.1
end:vcard


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux