|
-
date format in Oracle includes both date and time. your problem is only a display one. you can either select to_char(...,'DD/MM/YYYY') or alter your session so that display is changed :
alter session set NLS_DATE_FORMAT='DD/MM/YYYY HH24:MI:SS'
for the difference between 2 dates, no problem, you'll get the result as a number in days ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|