Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sysdate format
- Thread starter Leon1977
- Start date
Hi,
You get a timestamp format because the nls_date_format is defined with this format on the server side.
You have many solutions to solve your pb :
1/ select to_char(sysdate,'DD/MM/YYYY') from dual;
but it this return a varchar2 string.
2/ if you need the system date as a date :
select to_date(to_char(sysdate,'DD/MM/YYYY'),'DD/MM/YYYY') from dual;
NB : if you work on a indexed date field in a query using to_char(sysdate,...) or a to_date(to_char(sysdate,...)) , you will not used the index on the date field.
3/ Another solution is to alter your session on the client side (your SQL+ session):
alter session set nls_date_format ='DD/MM/YYYY'
and then call the PL/SQL commands.
Hope this help you.
Did02
You get a timestamp format because the nls_date_format is defined with this format on the server side.
You have many solutions to solve your pb :
1/ select to_char(sysdate,'DD/MM/YYYY') from dual;
but it this return a varchar2 string.
2/ if you need the system date as a date :
select to_date(to_char(sysdate,'DD/MM/YYYY'),'DD/MM/YYYY') from dual;
NB : if you work on a indexed date field in a query using to_char(sysdate,...) or a to_date(to_char(sysdate,...)) , you will not used the index on the date field.
3/ Another solution is to alter your session on the client side (your SQL+ session):
alter session set nls_date_format ='DD/MM/YYYY'
and then call the PL/SQL commands.
Hope this help you.
Did02
- Thread starter
- #3
- Status
