Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: In Oracle is there any function for TIMESTAMP?
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