Oracle ADF Development and Database Blog (WhiteNinja) - AL-Banna

Oracle ADF Development and Database Blog: "White Ninja".equals("Mohammad AL-Banna")

Wednesday, January 27, 2016

millseconds to CT date time zone

select to_char(from_tz(CAST (to_date('1970-01-01 00:00:00000','yyyy-mm-dd HH24:MI:SSSSS') +(wl_access_time)/(1000*24*60*60) AS TIMESTAMP),'GMT')at  TIME ZONE 'US/Central','YYYY-MM-DD HH:MI:SS') from wl_servlet_sessions;
Posted by ALBanna at 2:47 PM 1 comment:
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)



Linkedin Profile

Linkedin Profile

Blog Archive

  • ►  2019 (1)
    • ►  March (1)
  • ►  2017 (1)
    • ►  March (1)
  • ▼  2016 (1)
    • ▼  January (1)
      • millseconds to CT date time zone
  • ►  2015 (1)
    • ►  June (1)
  • ►  2014 (15)
    • ►  November (1)
    • ►  October (2)
    • ►  September (3)
    • ►  August (2)
    • ►  May (2)
    • ►  March (1)
    • ►  February (3)
    • ►  January (1)
  • ►  2013 (2)
    • ►  December (1)
    • ►  October (1)
  • ►  2012 (6)
    • ►  December (1)
    • ►  October (1)
    • ►  July (1)
    • ►  January (3)
  • ►  2011 (5)
    • ►  December (4)
    • ►  September (1)
  • ►  2010 (12)
    • ►  December (1)
    • ►  June (1)
    • ►  May (2)
    • ►  April (1)
    • ►  March (3)
    • ►  February (4)
Simple theme. Theme images by billnoll. Powered by Blogger.