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!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Easy one - how to refer to today's date?

Status
Not open for further replies.
pastasalad

pastasalad

Programmer
Mar 27, 2003
38
GB
Hi folks

I need to select only records where field-x = today's date. (DB2 UDB). Or even field-x = DATE(today's date).

I can't find the term used to refer to today's date (I have tried SYSDATE, TODAY, DATE, and some others).

Thanks if you can help.
 
Sort by date Sort by votes
Doh! CURRENT DATE is what I was after.

I'll get me coat.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
602
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
536
tekpr00
tekpr00
evr72
  • Locked
  • Question
Update field from one table with a join table
Replies
1
Views
404
evr72
evr72
cloudtwter
  • Locked
  • Question
CASE DATE
Replies
5
Views
339
cloudtwter
cloudtwter
OZMAN86
  • Locked
  • Question
How to get Last Month data in DB2
Replies
1
Views
338
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top