Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Posts
    50

    Unanswered: insert date problem

    database:
    Firebird Last release

    problem:
    When i insert date value into date field, then firebird change day.value with month.value. For example if i insert date value in format (dd/mm/yyyy) = 10/01/2005 , Firebirds inserts this value like 01/10/2005


    all my date value are in format dd/mm/yyyy

    when i insert date value using this query,

    insert into TABLE_NAME(FIELD_NAME), values('10/01/2005')

    then Firebird inserts this value like mm/dd/yyyy

    result is:
    Day = 01
    Month = 10
    Year = 2005

    ----------------

    when i insert date value using this query,

    insert into TABLE_NAME(FIELD_NAME), values('10.01.2005')

    then Firebird inserts this value like mm/dd/yyyy
    result is:

    Day = 10
    Month = 01
    Year = 2005

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    try this --

    insert into TABLE_NAME(FIELD_NAME), values('2005-01-10')
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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