| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 51580 | 2004-11-24 14:20:00 | whats the correct way to do SQL Select with Datetime? | Captive (3159) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 295950 | 2004-11-24 14:20:00 | “x from x where [datetime]=<#”&now()&”#” I have decided I want to move away from sessions because they can be a security hazard, as well as wanting to go ‘cookieless’. I was just wondering how I can compare the tblSession time to say =<DataAdd(“s”,600,Now()) [600 may be a specifiable time in a setting file]. It will need to compare with MM/D/YYY HH:MM minimum [Preferably seconds as well] |
Captive (3159) | ||
| 295951 | 2004-11-24 14:30:00 | The reason is i want to build a sesionless system with ASP.. i have had a go at doing with PHP which was a lot easier and is maybe with ASP.NET but i still use ASP V3/Classic Mostly | Captive (3159) | ||
| 1 | |||||