Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unhappy Unanswered: add Date and Time In Non english format(Farsi or arabic)

    Please Help me
    I want Store date and time in sql server tables but in non english format.
    For example Arabic or farsi
    How can i Do?
    Help meeeeeeeee

  2. #2
    Join Date
    Feb 2002
    I am not sure which format you want - but there are 2 Kuwaiti formats:

    Style Format
    130 dd mon yyyy hh:mi:ss:mmmAM
    131 dd/mon/yy hh:mi:ss:mmmAM

    You can alter your datetime data using the convert function. Look at convert in bol.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    Date and time are not stored in any "format" in the database. They are stored as numeric values indicating the days elapsed since a fixed point in time. What you are looking for is a way to display the datetime value in a particular format. You can use the convert function given by rnealejr when outputing your results, but generally issues of data-formatting and display should be handled by your user interface or reporting tool.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts