Someone could help me with this SELECT. I have a select that works perfectly for Access. How to convert to Oracle?
See below:
Select * From Cadastro WHERE dateDiff('s',
(Mid(Format([Data],'00000000'),7,2)+'/'+Mid(Format([Data],'00000000'),5,2)+'/'+Mid(Format([Data],'00000000'),1,4)+'
'+Mid( Format([Hora],'000000'),1,2)+':'+Mid(
Format([Hora],'000000'),3,2)+':'+Mid( Format([Hora],'000000'),5,2)),now()) > (Minuto * 60) ORDER BY Data, Hora
] The Time and Type Type field (I store the time as HHMMSS)
The Minute and type-type field
Transform the bank and time of the bank for DD / mm / YYYY HHMMSS and subtract with the current date / time. This difference should be larger than the field in minutes.
Thanks
Nadia