MSSQL – samo datum iz datetime 2

Problem:

zanima nas samo datum iz datetime polja kako bi ga usporedili sa nekim datumom:

Rješenje:




SELECT * FROM tablica WHERE
CONVERT(VARCHAR(10), mojDatum, 120)<='2014-04-01'

Međutim, ako datum napišemo kao 2014-4-1 ovo neće biti dobro jer se usporedba radi kao varchar, a ne date…
zato možemo:


SELECT * FROM tablica WHERE
DATEADD(dd, 0, DATEDIFF(dd, 0, mojDatum)) <= '2014-4-1'

ovo također igra… drugačiji oblik datuma za usporedbu..


SELECT * FROM tablica WHERE
DATEADD(dd, 0, DATEDIFF(dd, 0, mojDatum)) <= '2014-04-01'

http://systasis.biz/blog/?p=138

This entry was posted on Saturday, April 5th, 2014 at 1:21 pmand is filed under MSSQL Database Development. You can follow any responses to this entry through the RSS 2.0 feed. Responses are currently closed, but you can trackback from your own site.

Comments are closed.