SQL SERVER 2005 W/ PHP DATETIME ISSUES - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!


Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.


LitterbugLitterbug Posts: 10Member

I've recently started working for a company who does bespoke software but also a lot of "Off the shelf" software. I have recently been tasked to install one of their off the shelf products for a new client.

I have been faced with a few unexpected issues though.....although the datetime field is appearing to record in the British standard way (as it is on our test server) the date does not save, it puts in a NULL value and when it is returned (within the program) the date appears as 1st January 1970.

My main thought is that it must be a problem with the SQL SERVER 2005 the clients server is using as exactly the same code works fine on our test database (version 2005 again).

Has anybody came across this issue before? I have trawled google and forums all over the net with no result, I've tried changing the date settings on the system and it does nothing so if anyone has any thoughts on it please feel free to get back to me or we may lose out on quite a substantial amount of money (for the contract with the client)

Thanks all

Sign In or Register to comment.