Hi,
We have a column in oracle database with data type as varchar, but the values are date time (mm/dd/yyyy hh:mi AM) format -- (its a free text field where user capture transaction done in Dublin)
eg (6/25/2021 10:26 PM
10/21/2021 02:10 AM)
We need to find Date and time in PST for same
Note: Default DB time zone is in PST
select DBTIMEZONE from dual returns : -07:00
How can I convert this value to corresponding PST value in select statement (Need to create view)
we need to perform date difference with another column having date value after conversion.
Kindly advice
Thanks
Sana