tdignan87
Well-known member
- Joined
- Jul 8, 2019
- Messages
- 95
- Programming Experience
- Beginner
C#:
String deletecommod = db.Query<String>("UPDATE REQUIREMENTSH SET REQUIREMENTSH.DELETED = " + DateTime.Now.ToOADate() + "WHERE REQUIREMENTSH.CREATIONDATE >= DATEADD(day,-5, GETDATE()") .FirstOrDefault();
Hi i have a firebird database which it's datetime format is stored as a DOUBLE.
I cannot change this in the db.
What i need to do is update data in the tables for records older than 5 days. The query above isnt working. I've tried google but no luck. Could anyone help me please?
Thanks
Tom