Re: How to get the DATE part of a DATETIME datatype?

From: sameer_deshpande <sameer_deshpande_at_hotmail.com>
Date: 23 Jun 2005 13:38:41 -0700
Message-ID: <1119559121.010517.167650@z14g2000cwz.googlegroups.com>

In Oracle datetime datatype??? It must be timestamp

Is this what you want?

SQL> create table x (datum timestamp);
Table created.

SQL> insert into x values (sysdate);
1 row created.

SQL> select * from x;
DATUM

---

23-JUN-05 10.29.15.000000 PM SQL> select to_char(datum,'DD.MM.YYYY') from x; TO_CHAR(DA

---

23.06.2005

Sameer

PWalker wrote:
> Hi. Sorry I think i posted this message in the wrong forum...
>
> I was hoping someone could help me. I am trying to display the time part
> of a datetime datatype in my query (in this isntance the column containing
> the datetime datatype is called 'starttime'). How does one accomplish this?
> I want to see the time via a simple select statement:
>
> select starttime from mytable;
>
> I was trying to use 'convert' statements, but I wasnt able to get it
> working. Could someone tell me how to do this? I do not want to start
> configuring system files as the server is fairly locked down.
>
> Could anyone point me in the right direction?
>
> Thanks!
>
> cheers, peter
Received on Thu Jun 23 2005 - 15:38:41 CDT