Often times we need to see a given time-stamp column in a particular time zone. Without casting as well, oracle allows a very simple way -
SELECT <column-name> AT TIME ZONE <time zone> FROM <table-name>;
this method saves the expensive cast operations.
SELECT <column-name> AT TIME ZONE <time zone> FROM <table-name>;
this method saves the expensive cast operations.
No comments:
Post a Comment