SQL query error using to_char

Question

The last line of my query will not run without "not a valid month" error. I am trying to convert a start time in GMT to local time using an offset in one of the columns, then compare this to a date I have in a variable. It works without using the to_char and offset.

Any insight would be appreciated.

    AND to_char(CT.START_GMT + K.OFFSET/1440,'MM/DD/YYYY HH24:MM:SS') >=     TO_DATE('$From_Date', 'mm/dd/yyyy')

TO_DATE('$From_Date', 'mm/dd/yyyy') .. you have what is put inside $fromdate ? — Maheswaran Ravisankar
– Maheswaran Ravisankar, Commented Mar 8, 2014 at 5:03

Maheswaran Ravisankar · Accepted Answer · 2014-03-08 05:06:06Z

1

AND CT.START_GMT + K.OFFSET/1440 >=     TO_DATE('$From_Date', 'mm/dd/yyyy')

You don't need a TO_CHAR() conversion.. if CT.START_GMT is a DATE

If CT.START_GMT is not DATE/TIMESTAMP , then you need to do TO_DATE() with the right format.

answered Mar 8, 2014 at 5:06

Maheswaran Ravisankar

17.9k6 gold badges50 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SQL query error using to_char

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related