SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

to_char(<date_column>,'D')

user5716448Mar 12 2018 — edited Mar 12 2018

Hi,

version 11g r2

Have following in a pl/sql package

to_char(<date_col>,'D') to get day_of sale

When run in sql and on own pc in pl/sql procedure gives expected results - however when package being kicked off via server notice the day of =sale is 1 more than expected

e.g 22/03/2018 when run handson get 4 thursday as expected but 5 when kicked off on via server.

Whilst could look to adapt to pcik up day of sale by joining into a calendar table any thoughts on how we coudl esnure got consistent accurate results if use to_char(<date_col>,'D')

Thanks

This post has been answered by cormaco on Mar 12 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 9 2018

Added on Mar 12 2018

11 comments

1,354 views