Dumb date question of the day....

[simian336]

Ok, I am sure this is a format question but it would be nice to know how to set it.

This question came from a user, so... If I right click on a file with a date field and choose OPEN TABLE I get a date with the format:

10/26/1999 12:00:00 AM

If I choose

select mydate
from file

then I get a date in the format

2012-02-03 00:00:00.000

Any idea why the format is different and how to change it.

Thanks

Simi

 

[andreadd]

no clue about the why's but i recently had to do a query where the datetime had to be returned in a very particular format. I came across this url:

http://linesofcode.net/snippets/45

it shows all the different examples of datetime display and the magic number that you put in

so yours may be Select CONVERT(mydate, 0)

 

[bborissov]

Don't CONVERT date.
How you see the date is just a representation. It is NOT how the date is kept into the table.
So you can check SET DATEFORMAT in BOL. If you want to see the date in SSMS formatted as you want.
But if you develop an application then handle the date by your frontend.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[markros]

I got the same format in both cases. What is the default language in SQL Server and in the OS?

PluralSight Learning Library