Syntax: Get ( CurrentTimestamp )
Data type returned: Timestamp
Returns the current timestamp (date and time) according to the local system clock to the nearest second.
Note that a timestamp is stored internally as an integer that represents the number of seconds since 1/1/0001. Therefore, calculations that use seconds as the base unit can be performed on timestamp data types.
Get (CurrentTimeStamp) uses the date and time settings of the local machine (client) and may be less useful or accurate than Get (CurrentHostTimeStamp) in a database that is accessed by clients from different time zones.
Might return 1/25/2004 8:28:05 PM.
Extracts the date from a timestamp.
Extracts the time from a timestamp.
: FileMaker Specifications
FileMaker 8 Product Line
Specifications and Storage Limits
Field Types and Import/Export Formats
: Calculation Functions
Working with Calculations Primer
: Custom Functions
Custom Functions Primer
Useful Custom Functions
: Script Steps
Script Step Reference
: Quick Reference
FileMaker Error Codes
FileMaker Keyboard Shortcuts
FileMaker Network Ports
FileMaker Server Command Line Reference
FileMaker XML Reference
: Other Resources
Where to Go for More Information