[Resolved] Need to test Date portion only

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

[Resolved] Need to test Date portion only

Author

Topic

snufse
Constraint Violating Yak Guru

469 Posts

Posted - 2009-08-24 : 17:18:51

Have following query snippet:

update #Combined_ReceiptTable
set    #Combined_ReceiptTable.jde_gross_qty  = #JDE_ReceiptTable.jde_gross_qty,
       #Combined_ReceiptTable.jde_net_qty    = #JDE_ReceiptTable.jde_net_qty,
       #Combined_ReceiptTable.gross_qty_diff = #Combined_ReceiptTable.ac2_gross_qty - #JDE_ReceiptTable.jde_gross_qty,
       #Combined_ReceiptTable.net_qty_diff   = #Combined_ReceiptTable.ac2_net_qty - #JDE_ReceiptTable.jde_net_qty
from   #Combined_ReceiptTable, #JDE_ReceiptTable
where  #Combined_ReceiptTable.trans_date     = #JDE_ReceiptTable.jde_trans_date and
       #Combined_ReceiptTable.petroex_code   = #JDE_ReceiptTable.jde_petroex_code and
       #Combined_ReceiptTable.tank_id        = #JDE_ReceiptTable.jde_tank_id and
       substring(#Combined_ReceiptTable.ticket_no, 1, 16)      = substring(#JDE_ReceiptTable.jde_ticket_no, 1, 16)

Field #Combined_ReceiptTable.trans_date = 2009-07-30 14:29:43.540
Field #JDE_ReceiptTable.jde_trans_date = 2009-07-30 00:00:00.000

I need to compare date portion only. Not sure how to go about this. Thank you.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-08-24 : 17:38:59

where
DATEADD(DAY, DATEDIFF(DAY, 0, #Combined_ReceiptTable.trans_date), 0)
=
DATEADD(DAY, DATEDIFF(DAY, 0, #JDE_ReceiptTable.jde_trans_date), 0)

No, you're never too old to Yak'n'Roll if you're too young to die.