Oracle Date Type

[Nischal Tanna]

hi guys..
Actually i m converting sql queries to oracle 1s...
So i need some help..
Here i am..
I have a query which gets me the difference between two dates in seconds...
select convert(float,datediff(ss,convert(varchar,Shift_Master.First_Punch_Time,108),convert(varchar,Attendance.First_Intime,108)),108) from emp_master,Attendance,shift_master

what will be the oracle version of these query..

can any1 help me..
regards,
Nischal

[Jamie Robertson]

try:
SELECT ( date1 - date2 ) *24*60*60 FROM TABLE_1

[Rudy Dakota]

Hi there,
I 'll not be solving your problem but I have got two clues for you:
- looks like you got your dates stored in character columns You 'll need the TO_DATE function with a nice formatting string to make these values real dates (

TO_DATE(<date column>, '<format string>')

- in Oracle SQL the difference between two date values is always a number of days, so you 'll have to multiple it by 24 * 3600 to get seconds.
Good luck,
Rudy.