to_date

[TANUJ]

i m working on oracle forms 6i n enable to fetch the record in time format.

on form, field type is date with format mask hh24:mi
but when i fetch it using to_char function nd trans it into to_date func
only date show.. not time..

help me..

tanuj

[richasaraf]

to_date format

use the following pattern.... suppose you want date and not time then write query as :

select to_date(column_ name, 'DD-Mon-YYYY') from table_name;

Enjoy !!! :)

i m working on oracle forms 6i n enable to fetch the record in time format.

on form, field type is date with format mask hh24:mi
but when i fetch it using to_char function nd trans it into to_date func
only date show.. not time..

help me..

tanuj