Hi,
In SQL Server when I create a stored procedure, in the list of stored
procedures the Create Date column used to be formatted as:
28/09/2004 14:35:24
But since yesterday, for some reason, when a new stored procedure is
created, the date appear as :
2005-05-31 14:03:07.854

Why??!? This is very annoying to sort my procedures by date as it
messes up everything..

Regards

Sam (samuel.berthelot@voila.fr) writes:
> In SQL Server when I create a stored procedure, in the list of stored
> procedures the Create Date column used to be formatted as:
> 28/09/2004 14:35:24
> But since yesterday, for some reason, when a new stored procedure is
> created, the date appear as :
> 2005-05-31 14:03:07.854
>
> Why??!? This is very annoying to sort my procedures by date as it
> messes up everything..

SQL Server is a server application, so SQL Server itself does not
display anything. So apparently you see this in some client tool,
and thus the formatting depends on that tool. Since I don't know
which tool you use, I will have to guess a bit.

In Query Analyzer, dates are always displayed as YYYY-MM-DD HH:mm:ss.fff,
unless you check "Use regional settings" under Tools->Options.

In Enterprise Manager, under Databases->db->stored procedures there is
a listing. I would expect this listing to respect your regional settings.
Currently I see YYYY-MM-DD HH:mm:ss, which are my regional settings, but
this could very well be a hard-coded format.

I don't know about this screen, but I seem to recall that there are
other screesn in EM, when you sort on dates, it sorts the string, which
is a disaster with a format like DD/MM/YYYY.

Anyway, YYYY-MM-DD is the international standard for date formats, so
why not get used to it?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

why not get used to it?

Simply because stored procedures created before yesterday have the
format YYYY-MM-DD and the stored procedure that I create now have
another format, therefore I can't sort by date the list anymore or it's
messed up...

Sam (samuel.berthelot@voila.fr) writes:
> why not get used to it?
>
> Simply because stored procedures created before yesterday have the
> format YYYY-MM-DD and the stored procedure that I create now have
> another format, therefore I can't sort by date the list anymore or it's
> messed up...

Huh? Sounds very strange. First of all, whatever function you are using,
close it down and start it again. (Or just press a Refresh button.)

If the problem still is there, take a screen shot, put it on a web
site, and post the link.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

for some reasons, I've closed down sql server and all dates are in the
same format now.... weird... but my problem is solved anyway ...
thx

Sam (samuel.berthelot@voila.fr) writes:
> for some reasons, I've closed down sql server and all dates are in the
> same format now.... weird... but my problem is solved anyway ...

And whatever you closed down, I'm quite sure that it wasn't SQL Server.
You closed down some tool which you did not tell us what it was. I
might be pedantic by making this point, but in many situations it's
important to understand what is SQL Server what is the tool. SQL Server
itself does *not* have a user interface.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

By SQL Server, I meant Entreprise Manager... sorry for the confusion