Re: Concatenate

From: Carlos <miotromailcarlos_at_netscape.net>
Date: 16 Mar 2006 07:49:53 -0800
Message-ID: <1142524192.997478.146690@u72g2000cwu.googlegroups.com>

Oracle DATE handles DATES from year to second (so you likely don't need TIMESTAMP datatype).

But, JUST IN CASE, take a look at this:

sql> SELECT CAST(TRUNC(SYSDATE)+55000/86400 AS TIMESTAMP) "Timestamp" FROM DUAL; Timestamp

---

16/03/06 15:16:40,000000

HTH. Cheers.

Carlos. Received on Thu Mar 16 2006 - 09:49:53 CST