Down the Memory Lane: Sql inbuilt functions

10.04.2006

trunc(sysdate,'mm') ----> returns the starting date of the current month
trunc(sysdate.'y') -----> returns the starting date of the current year

Murari said...: Better start writing bigger posts mate, else you will end up with parapraxia; 1:12 AM