OraFAQ Forum: Forms » format mask and datatype: different between date and time

Home » Developer & Programmer » Forms » format mask and datatype: different between date and time

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

format mask and datatype: different between date and time [message #80942]

Mon, 16 December 2002 10:13

chow
Messages: 2
Registered: December 2002

Junior Member

create table ailec (
vdate date
start_clock date
end_clock date
)

what should i do to make the output

20-jan-2002 09:00 21:00

Report message to a moderator

Re: format mask and datatype: different between date and time [message #80955 is a reply to message #80942]

Tue, 17 December 2002 05:12

Piyush Balan
Messages: 26
Registered: December 2002

Junior Member

Hi,
for capturing the time element, simply use to_char(column_name, 'HH24:MI') . this will solve ur requirement.

Regards,
Piyush Balan
Consultant
Comsoft Pte Ltd
Singapore

Report message to a moderator

Urgent please [message #81770 is a reply to message #80955]

Tue, 18 March 2003 23:31

siraj
Messages: 2
Registered: August 2002

Junior Member

I want to use '0-00-000-0000-00000' this type of format mask in forms 6i. Please advise me.

Report message to a moderator

Previous Topic:	Orainst.exe error!!!! Kindly Help
Next Topic:	Forms6i(Parameter) Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 03:02:37 CDT 2024