hi
how to convert timestamps to date in oracle, and please give me example sql statements
help me
thanks
bala
balakrishnan.kb
0
Newbie Poster
Recommended Answers
Jump to Posttime stamp contains date as well . you need to trim the timestamp containing both date and time information to get only the date part.
All 4 Replies
debasisdas
580
Posting Genius
Featured Poster
time stamp contains date as well . you need to trim the timestamp containing both date and time information to get only the date part.
yogesh_vaidya12
0
Newbie Poster
Use To_Char function to get date in Desired Format.
balakrishnan.kb
0
Newbie Poster
k thanks, how to to trim the time stamp?help me
debasisdas
580
Posting Genius
Featured Poster
you need to use TRUNC() to remove the time information from the date field.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.