Inscrit le: 15 Déc 2017
|Posté le: Ven 30 Mar - 08:49 (2018) Sujet du message: Comparing a DateTime field with a Date
Datetime field with a Date. I get an typeWhen I want to do something like this:
select * from table1 where datum> DATE '2005-01-01'
The datum field is a DateTime. It works out when using a timestamp but in this case the values for the comparison are parameters. In some cases the user does not want to define a time but only a date. I could append 00:00:00 to th e date but then a record with a value in Datum of 2005-01-01 12:00:00 would be returned in the results and that is not what the user would expect. I do not know if it is not logical, but it seems logical that you would not like the date of a date.
I did not find the right solution from the internet.
Digital advertising studio