Product Logo

CNS Query

Query your databases without relationships.

Functions

CNSQuery_GetAsSQLTimestamp

NameCNSQuery_GetAsSQLTimestamp
Description

This function will convert a FileMaker Pro Timestamp value into an SQL Timestamp Format suitable for using in an SQL query.

Return TypeText
FormatCNSQuery_GetAsSQLTimestamp ( FMPTimestamp )
Required Parameters
FMPTimestamp

The FileMaker Pro Timestamp to convert to an SQL formatted Timestamp.

Example
Example 1

Returns something like: 2010-03-29 14:48:56

CNSQuery_GetAsSQLTimestamp( MyTimestamp )