Convert from Sybase to Oracle

Hi,
 How do I convert these from Syabse to Oracle

convert(varchar(11),Low,108)

convert(varchar(11),High,108)

...... AND convert(varchar(11),T.OrderDate,103) = convert(varchar(11), CurrentDate ,103)
madmareAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
...... AND convert(varchar(11),T.OrderDate,103) = convert(varchar(11), CurrentDate ,103)
should read

trunc(orderdate) = trunc(currentdate)
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
convert(varchar(11),Low,108)
reads
to_char(Low, 'HH24:MI:SS')

convert(varchar(11),Low,103)
reads
to_char(Low, 'DD/MM/YYYY')


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.