Datetime SQL problem

[#1]

Why is this date is not within my selection?

Thanks

[#2]

Thanks Honathan and Dennis...

You know how to add 1 second to a timestamp???

Paco

[#3]

Forgetting the question.

I've taken a look at this link, and I found the solution.

http://community.qlik.com/forums/t/34210.aspx

Round(Num(Date("Posting Date", 'DD/MM/YYYY'))) AS "Posting Date"

Thanks again Dennis