« previous next »
Pages: [1]

Author Topic: convert seperate date and time strings into a single date/time field  (Read 156 times)

Offline esanray

  • Senior Member
  • ****
  • Posts: 62
  • Forum Citizenship: +0/-0
convert seperate date and time strings into a single date/time field
« on: 20 Nov 2011 11:54:46 pm »
My model contain sch_date in a query item & sch_time in another query item.one is date datatype another is numeric data type.

sch date      sch time
18-NOV-11 0620
18-NOV-11 1705
18-NOV-11 2330
18-NOV-11 1500

Report Requre to display the value in timestamp format so i filter it from system time.
i write the following Query but its not working

TO_CHAR(TO_DATE(TO_CHAR(WOS.FLT_OPR.SCH_DATE ,'DDMONYY')||''||LPAD(WOS.FLT_OPR.SCH_TIME ,4,0),'DDMONYYHH24MI') 
 
Logged
Pages: [1]
« previous next »