 |  |  |  |  |  |  |  |
converting timestamp to date
Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
•
•
Join Date: Aug 2008
Posts: 24
Reputation: 
Solved Threads: 0
Newbie Poster
hi
how to convert timestamps to date in oracle, and please give me example sql statements
help me
thanks
bala
how to convert timestamps to date in oracle, and please give me example sql statements
help me
thanks
bala
time stamp contains date as well . you need to trim the timestamp containing both date and time information to get only the date part.
Share your Knowledge.
•
•
Join Date: Oct 2007
Posts: 11
Reputation:
Solved Threads: 1
Newbie Poster
Use To_Char function to get date in Desired Format.
•
•
Join Date: Aug 2008
Posts: 24
Reputation:
Solved Threads: 0
Newbie Poster
k thanks, how to to trim the time stamp?help me
|
Similar Threads
- Error when converting datestring from one form to another (Python)
- COnverting date time in windows to unix timestamp (C#)
- MySQL Timestamp into PHP Format (PHP)
- error C2664 (C++)
Other Threads in the Oracle Forum
- Previous Thread: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.
- Next Thread: Oracle 10g Screen not showing up
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest Oracle Posts
- Today's Posts
- Unanswered Threads
2009predictions acquisition amazon.com bartz bernanke cia citrix cloudcomputing crm database dell economy editor enterprise enterprise2.0 enterprisesoftware federalreserve forbes hp ibm intellipedia internet larryellison layoffs linux loughridge mediawiki michaeljackson microsoft neverland nortel notebooks oil operatingsystem oracle palm rimm saas salesforce sap seagate socialcomputing sql sun sybase technologystocks virtualiron virtualization vmware wiki wikipedia xen yahoo zoho
