Q.1 How can we get what is today (is it monday, tuesday or what...??) using PL/SQL... sysdate gives only the date ??
Q.2 How can i add 48 hours in SYSDATE. I have an Item_attribute of date format and i want to assign it a value if time say 48 hrs later. how can we achieve do this ??
We can get a Date using SYSDATE (in PL/SQL) in DD-MON-YYYY format.
We can use < select to_char(sysdate,'dd-mon-yyyy hh:mi:ss') from dual > query to get the time as well with date. But how can we add days or hrs to this characetr set. & convert it back to date format