Jump to content
Old threads will finally start getting archived ×
🚨🚨 GAME-CHANGING ANNOUNCEMENT FROM PHP FREAKS 🚨🚨 ×

SQL Server Time Stamps


Merlin 🤖

Recommended Posts

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?
Link to comment
https://forums.phpfreaks.com/topic/27691-sql-server-time-stamps/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.