Results 1 to 3 of 3

Thread: Date problem

  1. #1
    Join Date
    Jun 2002

    Unanswered: Date problem

    How date is stored in this database?

    My regional settings is in dd/mm/yyyy format
    when i am selecting current_date it is
    giving '01/07/2002'.

    I am having table with dailyid and reporteddate
    as columns.I am getting the values for the reporteddate
    from the frontend(textbox value).Textbox value
    is in dd/mm/yyyy format.

    when i am inserting values like '28/06/2002'
    it is inserting values into the database as
    i typed. But when i am inserting '07/06/2002' and
    '01/07/2002'.It is inserting date values
    as '06/07/2002' and '07/01/2002'.
    What's the problem?
    Why it is saving like this?Is there any solution
    for this?

  2. #2
    Join Date
    Sep 2001

    date problem

    I don't know whats going on there.

    But the best thing is you save the date with


    With this format you don't have any problems

    I have written an conversion layer cause my datestyle is

    so you can give in every date you need and send it through your conversion layer

    one big effort. solution forever
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Apr 2002
    Toronto, Canada
    to answer your question, santhi, date are stored as integers or floating-point numbers

    what you meant to ask was, "how do i insert dates, and how do i get them back out?"

    i agree with eperich, you will never have any trouble if you specify your dates in ISO standard format, yyyy-mm-dd

    check for more info


Posting Permissions

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