• Hi,

    You may try:

    SELECT convert(varchar(30),Getdate(),121) --2013-08-08 19:01:19.733