OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Date

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

Date [message #568700]

Tue, 16 October 2012 00:41

xerox2012
Messages: 15
Registered: October 2012

Junior Member

For an entered date, I want to hardcode the time part as 18:00:00, and rest of the date should be whatever is passed as input, how can i do this?

Report message to a moderator

Re: Date [message #568702 is a reply to message #568700]

Tue, 16 October 2012 00:47

muralikri
Messages: 638
Registered: August 2011
Location: chennai

Senior Member

You are excepting this one..

select to_date('10/12/2012'||'18:00:00','mm/dd/yyyy hh24:mi: ss') from dual

Report message to a moderator

Re: Date [message #568704 is a reply to message #568702]

Tue, 16 October 2012 01:11

xerox2012
Messages: 15
Registered: October 2012

Junior Member

My in parameter is as below :
in_sdate IN DATE DEFAULT (SYSDATE) - 1
I will now convert this in_sdate to CET format as
v_convert_date := f_convert_tzs (in_sdate, 'EST5EDT', 'CET');
Now again I calculate start date as
v_sdate := TRUNC (v_convert_date, 'MM');
which gives first of that month . Now I should get data from first of that month from 18:00:00 hrs only, not from 00:00:00
so i want to hardcode that 18:00:00 in my v_sdate , how can i get that?

Report message to a moderator