Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
timestamp filter
- Thread starter NigeB
- Start date
TonyGroves
Programmer
Assuming you're dealing with a standard TIMESTAMP field, you could use:
[tt]
WHERE SUBSTRING(ts,9,2)<'12'[/tt]
-----
ALTER world DROP injustice, ADD peace;
[tt]
WHERE SUBSTRING(ts,9,2)<'12'[/tt]
-----
ALTER world DROP injustice, ADD peace;
- Status
