• Why do you want to do this?  What are the requirements?

     

    Here is a fun "Select"

     

    SELECT DatePart(s, Getdate()), DatePart(s, Getdate()) + 1, GetDate(), DateAdd(s, 1, GetDate())