943,806 Members | Top Members by Rank

Web Development > Databases > Oracle > converting timestamp to date
Ad:
  • Oracle Discussion Thread
  • Unsolved
  • Views: 16377
  • Oracle RSS
Permalink
Sep 17th, 2008
0

converting timestamp to date

Expand Post »
hi
how to convert timestamps to date in oracle, and please give me example sql statements

help me


thanks
bala
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
balakrishnan.kb is offline Offline
24 posts
since Aug 2008
Permalink
Sep 19th, 2008
0

Re: converting timestamp to date

time stamp contains date as well . you need to trim the timestamp containing both date and time information to get only the date part.
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007
Permalink
Sep 23rd, 2008
0

Re: converting timestamp to date

Use To_Char function to get date in Desired Format.
Reputation Points: 10
Solved Threads: 1
Newbie Poster
yogesh_vaidya12 is offline Offline
11 posts
since Oct 2007
Permalink
Oct 1st, 2008
0

Re: converting timestamp to date

k thanks, how to to trim the time stamp?help me
Reputation Points: 10
Solved Threads: 0
Newbie Poster
balakrishnan.kb is offline Offline
24 posts
since Aug 2008
Permalink
Oct 2nd, 2008
0

Re: converting timestamp to date

you need to use TRUNC() to remove the time information from the date field.
Featured Poster
Reputation Points: 665
Solved Threads: 427
Posting Genius
debasisdas is offline Offline
6,406 posts
since Feb 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Oracle Forum Timeline: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
Next Thread in Oracle Forum Timeline: Oracle 10g Screen not showing up





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC