Date format

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.

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.