🎴 Flashcard Mode
Data Warehousing and Analytics Platforms
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
AnswerClick to flip back
A
$$$SessStartTime returns the session start time as string and SESSSTARTTIME returns as a date/time.
💡 Explanation:
The $$$SessStartTime system variable returns the session start time as a string representation, while SESSSTARTTIME returns it as a date/time object that can be used in date calculations. This distinction is important when you need to perform date arithmetic or formatting on the session start time. Option B is incorrect because $$$SessStartTime does not return an integer, and option C is incorrect because SESSSTARTTIME does not return an integer.