Brian Dunning's FileMaker Custom Functions

DateTime_From_TimeStamp ( FM_TimeStamp )

Takes a FileMaker Timestamp value and returns a MySQL DATETIME string

  Average rating: 4.2 (32 votes) Log in to vote

Gary Czychi   Gary Czychi
GC Consulting
http://www.Czychi.com/

Share on Facebook Share on Twitter

  Sample input:
DateTime_From_TimeStamp ( Get (CurrentTimeStamp )
  Sample output:
2010-04-15 19:59:17

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

Given a FileMaker Timestamp this function produces a MySQL DATETIME string. Could probably be streamlined, but it works well.

 

Comments

Jack Rodgers   Jack Rodgers, Hollywood, FL
May 4, 2010
Kinda misses the point...

getasdate (timestampfield )
and
getastime (timestampfield )

do the job far simpler...

:)
 
Jack Rodges   Jack Rodges, hollywood fl
May 4, 2010
ooppss.. should have read the mysql thing...

:):)
 
RJD   RJD, Brooklyn, NY
Jun 11, 2013
Thank you for sharing this with the community! Saves me some IF-statement writing for my current project.
Much appreciated.
 

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.