getdate  has_role

Chapter 2: Transact-SQL Functions

getutcdate

Description

Returns a date and time where the 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)

Usage

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

See also

Functions biginttohex, convert





Copyright © 2005. Sybase Inc. All rights reserved. has_role

View this book as PDF