Welcome, Guest. Please Login.
IRobotSoft Robot
11/17/19 at 09:37:44
News: Welcome to the IRoboSoft Visual Web Scraping and Web Automation forum.
Home Help Search Login
Google
 


Pages: 1
Send Topic Print
How to use to_date() and to_char() functions (Read 1326 times)
IRobotSoft Administrator
IRobotSoft Administrator
*****


IRobotSoft, the Best
Internet Robot
System

Posts: 1608
Gender: male
How to use to_date() and to_char() functions
10/18/09 at 20:53:27
 
These two functions are similar to the Oracle SQL syntax, so you can google it to get the format information.  Examples:  
 
to_char(sysdate(), 'YYYY/MM/DD HH24:MI:SS Day')  
would return '2009/10/18 20:41:56 Sunday'  
 
to_date('2009/10/18 20:41:56', 'YYYY/MM/DD HH24:MI:SS')  
would return a date.  
 
to_char(to_date('2009/10/18 20:41:56', 'YYYY/MM/DD HH24:MI:SS') , 'Day Mon DD, YYYY')  
would return 'Sunday Oct 18, 2009'.  
Back to top
 
 

The Administrator.
WWW   IP Logged
Pages: 1
Send Topic Print