Wednesday, April 23, 2014

Change the TIME to CDT time

CDT time format


select * from qp_edisbursement_candidate where load_timestamp =to_timestamp_tz('Tue Mar 11 06:30:38 CDT 2014','Dy Mon DD HH:MI:SS TZD YYYY');




CDT time format

('Tue Mar 11 06:30:38 CDT 2014','Dy Mon DD HH:MI:SS TZD YYYY');







No comments:

Post a Comment