Member Avatar for balakrishnan.kb

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

help me


thanks
bala

  • 3 Contributors
  • 4 Replies
  • 109 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

time stamp contains date as well . you need to trim the timestamp containing both date and time information to get only the date part.

Member Avatar for yogesh_vaidya12

Use To_Char function to get date in Desired Format.

Member Avatar for balakrishnan.kb

k thanks, how to to trim the time stamp?help me

Member Avatar for debasisdas

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.