Message Board


Message Board > Malarkey > SQL query

May 19, 2006, 15:28
Rhovanion
Exterminated
666 posts
what will the following SQL query return, and why?

select to_char(to_date('04-OCT-1582','DD-MON-YYYY')+1,'DD-MON-YYYY')
from dual

;)
____________
#
May 19, 2006, 19:04
Eckolin
Quite Whiskered
388 posts

It should return 15 October.
____________
Maker of Games...
Wisdom is supreme; therefore get wisdom.
Need help with coding? I probably wrote something similar.
#

Message Board > Malarkey > SQL query

Quick reply


You must log in or register to post.
Copyright © 2005 Booleansoup.com
Questions? Comments? Bug reports? Contact us!