Brian Dunning's FileMaker Custom Functions

TimestampFromSQLƒ ( _sqlTimestamp )

Converts SQL formatted timestamp to FileMaker formatted.

  Average rating: 4.3 (3 votes) Log in to vote

Michael Rhodes   Michael Rhodes
Allied Data Service
http://allieddataservice.com

Share on Facebook Share on Twitter

  Sample input:
TimestampFromSQLƒ ( "2017-03-17 14:11:17" )
  Sample output:
3/17/2017 2:11:17 PM

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Converts SQL formatted timestamp to FileMaker formatted.

 

Comments

19752   19752, Japan
Mar 20, 2017
You can use "+" as Japanese formatted timestamp, so

GetAsTimestamp(Substitute(_sqlTimestamp;"-";"+"))

would work as same.
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.