.NODE

Get(CurrentTimestamp)

Category: Get

Syntax: Get ( CurrentTimestamp )

Parameters: None

Data type returned: Timestamp

Description:

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.

Examples:

Function

Results

Get (CurrentTimeStamp)

Might return 1/25/2004 8:28:05 PM.

GetAsDate (CurrentTimeStamp)

Extracts the date from a timestamp.

GetAsTime (CurrentTimeStamp)

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

Calculation Signatures

Calculation Functions

: Custom Functions

Custom Functions Primer

Useful Custom Functions

: Script Steps

Scripting Primer

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

show all menu





FileMaker 8 Functions and Scripts Desk Reference
FileMaker 8 Functions and Scripts Desk Reference
ISBN: 0789735113
EAN: 2147483647
Year: 2004
Pages: 352
Similar book on Amazon

Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net