Date format

[Tino B.]

I've got some problems with date format (day and month result inverted) during
the execution of a stored procedure.
To obtain server settings, I have used the following statements:

select @@language
select @@langid
select convert(char(30),current_timestamp)

Is there any alternative way to discover date format?
Thanks in advance.

[Rob Vieira]

Based on the language ID, you can pick it up from syslanguages in the master
database. It will be presented there as dmy, mdy, or ymd.


--
Rob Vieira MCSD, MCT, MCDBA
www.ProfessionalSQL.com


"Tino B." <fb_tino@jumpy.it> wrote in message
news:3a714db3$1@news.devx.com...
>
> I've got some problems with date format (day and month result inverted)
during
> the execution of a stored procedure.
> To obtain server settings, I have used the following statements:
>
> select @@language
> select @@langid
> select convert(char(30),current_timestamp)
>
> Is there any alternative way to discover date format?
> Thanks in advance.