| orasab |
Posted: Jan 19, 2008 01:11:35 AM |
Total Post: 9
Joined: Jan, 2008
|
| Well can anyone tell me how can i query the date in format "YYYY-MM-DD"? |
|
|
Mohammed Taj |
| Posted: Jan 19, 2008 02:26:08 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
use to_char with date format
select to_char(sysdate,'YYYY-MM-DD') from dual;
|
|
|
|
|
sara |
| Posted: Jan 19, 2008 07:47:25 AM | |
|
Total Post: 7
Joined: Oct, 2007
|
use to_char function
to_char( 'date to be converted','format u want the o/p to be)
|
|
|
|
|
Mohammed Taj |
| Posted: Jan 19, 2008 07:54:32 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
What you new suggest except my previous post ?
|
|
|
|
|
jayesh |
| Posted: Jan 20, 2008 04:39:26 AM | |
|
Total Post: 60
Joined: Jan, 2008
|
well i have one query regarding that
suppose if i was to use yyyy-mm--dd format in a parameter of a procedure where datatype is DATE is it possible to do it coz for yyyy-mm--dd, u suggested to use to_char function.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |