Compare to dates
Posted: Tue 02 Feb 2016 14:38
I have a date compare problem:
In T-SQL I have this solution:
Select * from MyTable where convert(Date,ADay,104) = convert(Date,@Mydate,104)
Whats happends is that 104 changes the date to the same date formats.
What is best pactice in a DevArt Oracle environment ?
In T-SQL I have this solution:
Select * from MyTable where convert(Date,ADay,104) = convert(Date,@Mydate,104)
Whats happends is that 104 changes the date to the same date formats.
What is best pactice in a DevArt Oracle environment ?