Getting the hour,seconds and minutes of a date data
742228Jan 8 2010 — edited Jan 8 2010Hi -
I have a query:
select vdate from period;
the datatype of the column vdate is a date datatype set as NOT NULL.
However, whenever a querying is done on this table - it is not returning the hours,minutes and seconds. It is always being displayed as:
22.11.2008 00:00:00
I would like to know how i can obtain the exact values for the hours,minutes and seconds from the vdate column.
I cannot redeclare this column. I would like to have a function which would show the hours,minutes and seconds.
Please advise.
Regards -
Sandeep