date question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: date question

  1. #1
    Join Date
    Jul 2000
    Location
    brewster,Newyork
    Posts
    87
    Folks,

    generally if i return data from a table with date column i get values
    of sysdate means EST,,,but i need it in GMT format,,could u help me to resolve this issue.as its very urgent
    sat
    sat

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Set the appropriate NLS_... parameter., or you could also use the new_time function in your query.

    Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width