lundi 29 février 2016

DateAdd function in Sqlite server with column name as input

select DATE(Orders.OrderDate,'10 DAY') from Orders. it will give the following result "1996-07-14"

When using column name directly instead of value in numeric it will give the empty result select DATE(Orders.OrderDate,'Orders.OrderId DAY') from Orders.

What wrong with the above select query?

Aucun commentaire:

Enregistrer un commentaire