Results 1 to 3 of 3

Thread: date problem

  1. #1
    Join Date
    Aug 2003
    Posts
    26

    Unanswered: date problem

    Hello,

    I got 4 text items in a form , STARTDATE, STOPDATE (of Data Type: Date),
    and STARTTIME, STOPTIME (of Data Type: Datetime) in a form which serve as
    input parameters for a stored procedure (all 4 of type date in procedure header)

    Then I would like to concatenate STARTDATE and STARTTIME to datestart
    and STOPDATE and STOPTIME to datestop with:

    datestart VARCHAR2(20);
    datestart := TO_CHAR(STARTDATE, 'dd.mm.yyyy')||' '||TO_CHAR(STARTTIME, 'hh24:mi');


    The procedure includes
    SELECT ONE, TWO, THREE FROM MYTABLE
    WHERE TIMECOL >= TO_DATE(datestart,'dd.mm.yyyy HH24:MI')
    AND TIMECOL <= TO_DATE(datestop,'dd.mm.yyyy HH24:MI')

    But this seems not to work.

    Please help

  2. #2
    Join Date
    Aug 2004
    Location
    France
    Posts
    754
    What exact error do you get ?

    Is TIMECOL of datatype DATE ?

    Regards,

    RBARAER

  3. #3
    Join Date
    Jul 2003
    Posts
    2,296
    why do you need startdate and starttime??
    dates have time in them already.
    please explain. also, if you supply the desciption of the table and
    some sample data it would speed things up.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

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