Re: In Oracle is there any function for TIMESTAMP?

From: Stefan Grundmann <s.grundmann_at_t-online.de>
Date: Thu, 24 Aug 2000 19:40:38 +0200
Message-ID: <8o3ma7$lt0$17$1@news.t-online.com>

In Oracle the datatype date includes the time. You have to format the output to show the time with
to_char(your_date_field, 'DD.MM.YYYY HH24:MI:SS') (here german format). Look at the Oracle-doku for other format-strings.

Hope this helps,
Stefan

Globalink <wasiq_at_ibos.com> schrieb in im Newsbeitrag: mscp5.215$1I4.10147_at_newsfeed.intelenet.net...
> Hi, i'm porting a db from MS SQL 7 to Oracle 8i
> on Win NT 4.0.
>
> In MSSQL i have a column of type datetime and default value
> getDate() which returns current date and time.
>
> What is the function in Oracle which returns timestamp in Oracle?
>
>
> Thanks
> Wasiq Hasan
Received on Thu Aug 24 2000 - 12:40:38 CDT