SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Mar 2005
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    History Table -- hs_change_date

    I am trying to get rows out of the history table after a certain date.

    I've tried several examples that I've found else where, but can't get them to work. We are using TD 8.0 with an oracle database.

    Any suggestions would be appreciated.

    SELECT * FROM HISTORY
    WHERE HS_CHANGE_DATE > '01-FEB-2005' AND HS_COLUMN_NAME = 'BG_STATUS'

    SELECT * FROM HISTORY
    WHERE HS_CHANGE_DATE > '02/01/2005' AND HS_COLUMN_NAME = 'BG_STATUS'

    SELECT * FROM HISTORY
    WHERE HS_CHANGE_DATE > 02/01/2005 AND HS_COLUMN_NAME = 'BG_STATUS'

  2. #2
    Junior Member
    Join Date
    Mar 2003
    Location
    Germany
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: History Table -- hs_change_date

    The HS_CHANGE_DATE is a date field. Maybe you should try it using

    </font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">select * from history where hs_change_dat &lt; TO_DATE('23.02.2005', 'DD.MM.YYYY')</pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">That should work.
    Holger

    -------------------------
    http://www.qatools.de

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 06:04 AM.

Copyright BetaSoft Inc.