Different Query Result in SQL Server 2005

Question

I have a table in SQL Server 2005, and it has column period (datetime).

The value of the column period is 8/7/2009 12:00:00 AM, when I query using php script it give me output Aug 7 2009 12:00AM.

Why it's not 8/7/2009 12:00:00 AM ???

Thank you

They look the same to me. Do you not like the way the PHP script formats DateTime values? — HABO
– HABO, Commented May 3, 2013 at 1:49

RichardTheKiwi · Accepted Answer · 2013-05-03 02:15:53Z

3

Your question reads like this:

The value of the column period is
{ a date, year 2009 month August day 7th at 12:00 AM}
When I query using php script it give me output "Aug 7 2009 12:00AM", i.e. one representation of the date.
Why it's not "8/7/2009 12:00:00 AM", i.e. another representation of the date

A datetime represents a point in time. It is a specific concept. You are comparing two separate representations of the datetime, or in other words, two ways of formatting the datetime value as a textual string.

The issue you are trying to solve is then, "How do I format a datetime as a string in PHP"? For which the answer would be to refer to the date_format (aka DateTime::format) function

To wit, the display specifier for 8/7/2009 12:00:00 AM is n/j/Y h:i:s A.

answered May 3, 2013 at 2:15

RichardTheKiwi

108k28 gold badges206 silver badges269 bronze badges

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

1 Comment

Plipus Tel Over a year ago

I just wondering why it doesn't give me "what I see is what I get" without formatting the result query. lol... Thank Richard

Collectives™ on Stack Overflow

Different Query Result in SQL Server 2005

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related