Date format


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Date format

  1. #1
    Tino B. Guest

    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.
    Share on Google+

  2. #2
    Rob Vieira Guest

    Re: Date format

    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.



    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center