PHP with SQL Server: strtotime() with SQL Server DATETIME column

Question

So I have SQL Server datetime field, and in PHP I want to use this as a UNIX TIMESTAMP, because I want to use it with strtotime, in order to add 14 days into it. Eg. If it is stored in the SQL Server database as: 2010-07-27 13:12:22.040 I want to add 14 days into it to become 2010-08-10 13:12:22.040

How would I do that using PHP with SQL Server datetime field? strtotime() command takes only UNIX timestamp.

If can't be done in PHP with SQL Server , how would I do it in SQL Server and then select it with the values I am selecting?

OMG Ponies · Accepted Answer · 2010-07-28 01:10:54Z

1

how would I do it in SQL Server and then select it with the values I am selecting?

Use DATEADD:

SELECT DATEADD(dd, 14, date_column)

...to add 14 days to the column value.

answered Jul 28, 2010 at 1:10

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rostyslav Dzinko · Accepted Answer · 2012-08-21 09:51:29Z

0

strtotime() takes a string date format, but anyway, you can also look into mktime().

edited Aug 21, 2012 at 9:51

Rostyslav Dzinko

41k5 gold badges55 silver badges66 bronze badges

answered Jul 28, 2010 at 0:00

CrayonViolent

32.6k6 gold badges61 silver badges80 bronze badges

2 Comments

CrayonViolent Over a year ago

or do it directly in sql using adddate() or addtime()

JoHa Over a year ago

Thanks, I used DATEADD instead

Collectives™ on Stack Overflow

PHP with SQL Server: strtotime() with SQL Server DATETIME column

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related