Re: how to get the time part of a DATETIME datatype?

"PWalker" <pwalker_at_nospam.com> wrote in message news:42b938cd_at_dnews.tpgi.com.au...
> Hi, 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
>

for display, you want TO_CHAR with the appropriate format model, as listed in Oracle's SQL manual

++mcs Received on Wed Jun 22 2005 - 05:13:35 CDT