SQL Question

[tunjio]

I have got a date field - ACTUAL_START - stored as a varchar and managed to change this to a a date field by doing the following:

TO_DATE(ACTUAL_START,'HH24:MI:SS')

Thi sgives me something like this 01/08/2007 08:50:04

However what I need to do is to retrieve the time portion of this field, i.e. 08:50:04

Can anyone advise on how to do this?


Regards,
Tunji

 

[mrdenny]

What platform are you using?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[tunjio]

Orace 9i

 

[mrdenny]

You will want to post this in the correct Oracle forum
forum185
forum186
forum759
forum1177
forum1662

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com