TimestampFromSQLƒ ( _sqlTimestamp )

Converts SQL formatted timestamp to FileMaker formatted.

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

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

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)

/*
  Created by Michael Rhodes
  mike@allieddataservice.com
*/

If (
	_sqlTimestamp ;

	Timestamp (
		Date (
			Middle ( _sqlTimestamp ; 6 ; 2 ) ;
			Middle ( _sqlTimestamp ; 9 ; 2 ) ;
			Left ( _sqlTimestamp ; 4 )
		) ;
		Time (
			Middle ( _sqlTimestamp ; 12 ; 2 ) ;
			Middle ( _sqlTimestamp ; 15 ; 2 ) ;
			Right ( _sqlTimestamp ; 2 )
		)			
	)

)

Converts SQL formatted timestamp to FileMaker formatted.

Comments

		19752, Japan Mar 20, 2017
You can use "+" as Japanese formatted timestamp, so GetAsTimestamp(Substitute(_sqlTimestamp;"-";"+")) would work as same.

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

TimestampFromSQLƒ ( _sqlTimestamp )

Comments

Support this website.

Support this website.