ReturnAsLocalFormat SQL / ExecuteSQL function

Idea created by Vincent_L on Jun 16, 2018
    Active
    Score1
    • Vincent_L

    Hi,

     

    Following-up this idea Improve ExecuteSQL Date and Timestamp handling I propose to add a new function in Filemaker's SQL / ExecuteSQL implementation that would return data in the filemaker native format according to running OS localization settings.

     

    For instance, Select ReturnAsLocalFormat("date") WHERE "date"='16/6/2018' would return '16/6/2018' on French OS instead of '2018-06-16' like just "date" would return, whereas it would return 2018/06/16 on US OS.


    Same would go form timestamps, and for decimal numbers

     

    Select ReturnAsLocalFormat("decimal") WHERE "decimal"='16,5' => 16,5 on french, 16.5 on us

    Select ReturnAsLocalFormat("timestamp") WHERE "timestamp"='16/06/2018 12:35:00' => '16/06/2018 12:35:00' on french, '2018/06/2016 12:35:00' instead of 2018-06-16 12:35:00