Skip to main content
Version: 8.1

system.db.dateFormat

This function is used in Python Scripting.

Description

This function is used to format dates nicely as strings. It uses a format string to guide its formatting behavior. Learn more about date formatting in Dates.

Client Permission Restrictions

This scripting function has no Client Permission restrictions.

Syntax

system.db.dateFormat(date, formatPattern)

Parameters

TypeParameterDescription
DatedateThe Date object that you'd like to format
StringformatPatternA format pattern string to apply. Refer to Data Type Formatting Reference for a table of acceptable symbols.

Returns

String - The date as a string formatted according to the format pattern.

Scope

Gateway, Vision Client, Perspective Session

Code Examples

# This example displays a message box on a button press that displays the selected date (without the time)
# from a Calendar component, in a format like "Feb 3, 2009"
date = event.source.parent.getComponent("Calendar").latchedDate
toDisplay = system.db.dateFormat(date, "MMM d, yyyy")
system.gui.messageBox("The date you selected is: %s" % toDisplay)
# This example does the same as the one above, but also displays the time, in a format like: "Feb 3, 2009 8:01pm"
date = event.source.parent.getComponent("Calendar").latchedDate
toDisplay = system.db.dateFormat(date, "MMM d, yyyy hh:mm a")
system.gui.messageBox("The date you selected is: %s" % toDisplay)
# This example takes two dates from two Popup Calendar components, formats them in a manner that the database understands,
# and then uses them in a SQL query to limit the results to a certain date range.
startDate = event.source.parent.getComponent("StartDate").date
endDate = event.source.parent.getComponent("EndDate").date
startDate = system.db.dateFormat(startDate, "yyyy-MM-dd HH:mm:ss")
endDate = system.db.dateFormat(endDate, "yyyy-MM-dd HH:mm:ss")
query = ("SELECT * FROM mytable WHERE t_stamp >= '%s' AND t_stamp <= '%s'" % (startDate, endDate))
results = system.db.runQuery(query)
event.source.parent.getComponent("Table").data = results

Keywords

system db dateFormat, db.dateFormat