var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get All Records from timestamp
I need to retreive all records for todays date something like this
where A = ??
So A should match all data for todays date and ignore all time data
What do you know about date/time/timestamp calculations on DB2?
Did you read this article?
DB2 Basics: Fun with Dates and Times
What did you tried? What result(or error) did you got from the trial?
I'm totally from sybase dont know much on db2
I tried this and it works
where DATE(COLUMNA) = DATE('2009-11-28')
also for current date
where DATE(COLUMNA) = DATE(current date)
but how do i get a previous date record say something like this
DATE(current date) - 1
current date - 1 DAY
there is no need to use DATE() with current date
Yeah this worked.Still learning DB2 ;-)