Dates & Datetimes when reading from MSSQL in PHP

Dates & Datetimes when reading from MSSQL in PHP

So it gets me every time I try to deal with dates in a query result when I’m getting rows from a MSSQL database in PHP. Normally I work with MySQL when I’m programming in PHP, but I have a hybrid application where .Net is used on the front end, and I do a bunch of back end things using PHP scripts. So here’s the issue. MSSQL doesn’t store things the same way MySQL does. MySQL seems to treat everything like a string. ...

Read More

The MySQL now() function in MSSQL

If I want to insert the current time into a field when doing an insert in MySQL I usually use the NOW() function. It’s built right into the query string and makes sure you get the time of insert. In MSSQL though you have to change things to getDate(). If you have a date field, it will adapt to your type, but you can also specify a format of the date as the parameter.

Read More

Selecting a running position of the returned row in MSSQL

For some reason this concept is hard to summarize in one line. Basically we’re looking to return how many rows are in the table before the row returned in the result. Sort of like what position the rows is in line. If we have a table like this: Row: 1,2,3 Row: 2,4,5 Row: 3,6,7 And we want to find out the position of row 2, then it’s fairly simple because the primary key will tell us what order it is. However, if you delete row 1,...

Read More