imartin Posted November 18, 2006 Share Posted November 18, 2006 I have a MS Sql table with a date field, the dates are in the Sql server timestamp format (number of minutes since the Universal Benchmark (midnight Jan 1 1900)). I'm using PHP to run queries such as [code]SELECT * FROM MyTable WHERE DateField > $date[/code]I know there is an easy way for the query to take $date as a UNIX TIMESTAMP and compare it to the time stamp format mentioned above because I have done it before, but I can't remember how I did it.Whats the best way to do this? Quote Link to comment https://forums.phpfreaks.com/topic/27691-sql-server-time-stamps/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.