Sitemap
 

Oracle SYSDATE Function

SYSDATE       The current system date & time


TO_CHAR       Convert to character String

select TO_CHAR(sysdate)  from dual
result: 14-MAR-08

select TO_CHAR(sysdate,'DD-Mon-YYYY')  from dual
result: 14-Mar-2008

select TO_CHAR(sysdate,'DD-Mon-YYYY HH24:mi:ss')  from dual
14-Mar-2008 15:40:45



   
Page  1
 
Earn Money
Make Web Sites
Free Web Tools
Most searched EBooks
Help us to maintain this site free
© Copyright 2004-2007 www.easywebtech.com   
All Rights Reserved.   
Privacy policy
Earn Money with adsense Adsl wifi

technorati technorati