Archives of the TeradataForum
Message Posted: Mon, 08 Dec 2008 @ 14:16:19 GMT
Good day all, I am doing a compare of a dat with the timestamp on a table. I am currently using the following SQL:
select count(*) from ui.wagedetail where Cast(wdmodificationtime as date format 'YY/MM/DD' ) >= '08/10/14'
This works but I am wondering if there is a better or more efficient ay to do it.
Thanks for any and all assistance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|