sp_sysmon  Changed commands

Chapter 15: Changes to Stored Procedures, Functions, and Commands

New function

Function

getutcdate()

Description

Returns a date and time whose value is in Universal Coordinated Time (UTC). getutcdate is calculated each time a row is inserted or selected.

Syntax

insert t1 (c1, c2, c3) select c1, getutcdate(), getdate() from t2



Copyright © 2005. Sybase Inc. All rights reserved. Changed commands

View this book as PDF