How do i write a function in PL/SQL which returns current date and time in number format.?

Question

How do i write a function in PL/SQL which returns current date and time in number format.?

Answer 1

Java question and answer-http://javaanswers1.blogspot.com/

Answer 2

Not sure what you mean by number format, but if you want to use SQL to select the day, month, year, hour minute etc value, you can use:

SELECT DATEPART(day, SelectingDate) from TABLE

Where SelectingDate is the field you want to get the values from.

Change day with month year etc  

Answer 3

select CURDATE() from dual;