Home » SQL & PL/SQL » SQL & PL/SQL » Truncate date string to mm/yyyy
Truncate date string to mm/yyyy [message #218550] Thu, 08 February 2007 11:02 Go to next message
sharaiqa
Messages: 7
Registered: February 2007
Junior Member
Hello Forum,

Does anyone know how to truncate a date string so that it will only return mm/yyyy using to_char
Re: Truncate date string to mm/yyyy [message #218551 is a reply to message #218550] Thu, 08 February 2007 11:07 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Don't cross post and why do you think this should be in the PL/SQL Expert forum anyway or SQL Expert as your cross post is posted in?

[Updated on: Thu, 08 February 2007 11:09]

Report message to a moderator

Re: Truncate date string to mm/yyyy [message #218553 is a reply to message #218551] Thu, 08 February 2007 11:19 Go to previous messageGo to next message
sharaiqa
Messages: 7
Registered: February 2007
Junior Member
I am sorry if I have done something wrong... and why are you being so nasty... I am new to the forums and I am not sure how they work. I thought this was a place that I can go for help...not be treated with such self-righteousness... If you are not going to help me, please don't reply.


[Mod edit: Removed idiotic fontsize]

[Updated on: Thu, 08 February 2007 12:09] by Moderator

Report message to a moderator

Re: Truncate date string to mm/yyyy [message #218556 is a reply to message #218553] Thu, 08 February 2007 11:24 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
I apologize, I didn't mean to be crass with my response, but in being new to a forum, you should review the stickies at the top of each forum.

If you look at your cross post you'll see that I did provide an answer.
Re: Truncate date string to mm/yyyy [message #218557 is a reply to message #218556] Thu, 08 February 2007 11:31 Go to previous message
sharaiqa
Messages: 7
Registered: February 2007
Junior Member
No worries.. thanks for your help! I really appreciate it! Razz
Previous Topic: Date time in my sql
Next Topic: SQL%ROWCOUNT reporting 1 even though there is no records affected
Goto Forum:
  


Current Time: Fri Dec 02 20:44:54 CST 2016

Total time taken to generate the page: 0.07583 seconds