ns_parsesqltimestamp

Overview

Return time, AM/PM designation, year, month, or day of specified SQL timestamp

Syntax

ns_parsesqltimestamp opt sqltime

Description

ns_parsesqltimestamp returns one of the time elements or one of the date elements of the SQL timestamp value in sqltime. Valid opt values are:

opt	Description
time	return clock time
ampm	return AM or PM designation
year	4-digit year (e.g., 1965)
month	capitalized month name in English (e.g., February)
day	day of the month (1-31)