Adding seconds to Date SQL

Adding seconds to Date SQL

References

Reference NO 1

http://stackoverflow.com/questions/3480784/sql-server-add-seconds-to-a-datetime-field

Reference NO 2

http://www.w3schools.com/sql/func_dateadd.asp

Reference NO 3

http://technet.microsoft.com/en-us/library/ms186819.aspx

Reference NO 4

http://www.orafaq.com/faq/how_does_one_add_a_day_hour_minute_second_to_a_date_value

Reference NO 5

http://www.sqlservercentral.com/Forums/FindPost152506.aspx

Reference NO 6

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69558

Reference NO 7

http://dba.stackexchange.com/questions/18042/convert-a-datetime-column-to-number-of-seconds

Reference NO 8

http://www.mssqltips.com/sqlservertip/2509/add-and-subtract-dates-using-dateadd-in-sql-server/