-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alvaro Herrera wrote: > Chris Hoover wrote: >> I have several columns in my database that are timestamps. My developers >> are asking me how to split the timestamp so that they can look at either the >> date or at the time portion. >> >> 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? Also, is this the proper way to get >> the date portion of a timestamp? > > select now()::timetz; > select now()::time; > select now()::date;
What's the inverse? Say I have a DATE and a TIME, and want to create a TIMESTAMP with them? - -- Ron Johnson, Jr. Jefferson LA USA Is "common sense" really valid? For example, it is "common sense" to white-power racists that whites are superior to blacks, and that those with brown skins are mud people. However, that "common sense" is obviously wrong. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFEzGPIS9HxQb37XmcRAgWyAKCE/xGJrieisqqHcwxFGcreQfFG8wCggL8n wiDGRD0xekMKVb01R1uPM4I= =hE1R -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings