Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Location
    Recife - PE - Brazil
    Posts
    28

    Exclamation Unanswered: Datatime order by Problem

    Hi everybody,
    I have onde table called (TB) with two fields : F1(int) and F2(varchar:10)
    In this table the field F2 is used to store dates in the format
    dd/mm/yyyy (27/12/2002). Its is record as varchar and undesired.
    I need to select all records from a single id from the field F1 and
    then order by the result set by date to result set be this way:

    F1 F2
    --------------------------------------
    01 15/12/1975
    01 15/12/1980
    01 16/12/1998
    01 27/12/2003
    --------------------------------------

    To do this Im using the follow syntax :

    SELECT * FROM TB
    WHERE (F1 = '01')
    ORDER BY CAST(F2 AS datetime(103))

    But it gives the follow message erro trying to select data :

    [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.


    How can I convert the format used in the select to order by date type in a SQL Server range datetype to get a result set as above?

    Thansk for attention.

    Leonardo Almeida

  2. #2
    Join Date
    Oct 2003
    Location
    Ireland
    Posts
    54
    Use convert(datetime, f2, 103) instead of the cast.

Posting Permissions

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