UTpaper

Free mock tests & test series

Question 104Asked in DSSSB TGT Computer Science, 7 Feb 2024, Shift 2 (12:30 PM)

Which of the following data function in SQL returns the current database system

Which of the following data function in SQL returns the current database system timestamp as a ‘datetime’ value without the database time zone offset?
  1. AGET T IME
  2. BGET DAT E
  3. CCAST DAT E
  4. DCAST T IME
Show answerHide answer

Correct answer: (B) GET DAT E

Explanation

GETDATE() in SQL Server returns the current database system timestamp as a datetime value without the time zone offset.

From DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM)

This is question 104 of DSSSB TGT Computer Science PYQ, 7 Feb 2024, Shift 2 (12:30 PM). See all questions of this paper with answers, or attempt the paper as a timed online test to get your score and all-India rank.