Change Password

Please enter the password.
Please enter the password. Between 8-64 characters. Not identical to your email address. Contain at least 3 of uppercase, lowercase, numbers, and special characters (such as @*&#).
Please enter the password.
Submit

Change Nickname

Current Nickname:
Submit

Certifications

Certificate Issued at Valid until Serial No. File
Serial No. Valid until File

Not having one? Apply now! >>>

Invoice

ProductName CreateTime ID Price File
ProductName CreateTime ID Price File
v4.2
Search
    中文EN
    v4.2

      dateFormat()

      Function dateFormat() converts a time value to a string in the specified format and returns that string.

      Arguments:

      • Time <datetime | timestamp | string>
      • Format <string>

      Returns:

      • Time string <string>

      Code of format:

      Code Description Example
      %a Abbreviated name of day of week in system language (en_US) Sun, Mon, ...
      %A Full name of day of week in system language (en_US) Sunday, Monday, ...
      %b Abbreviated name of month in system language (en_US) Jan, Feb, ...
      %B Full name of month in system language (en_US) January, February, ...
      %c Default date and time format in the system settings 'Wed Jan 11 10:59:28 2023'
      %C Number denoting century (year divided by 100) 00, 01, ..., 99
      %d Day of month (zero-padded) 01, 02, ..., 31
      %D Alternative code of %m/%d/%y '01/11/23'
      %e Day of month 1, 2, ..., 31
      %Ez Time zone '+08:00'
      %g Year in 2 digits (without century) 00, 01, ..., 99
      %G Year in 4 digits 0000, 0001, ..., 9999
      %h Alternative code of %b See example of %b
      %H Hour of 24-hour clock (zero-padded) 00, 01, ..., 23
      %I Hour of 12-hour clock (zero-padded) 01, 02, ..., 12
      %j Day of year (zero-padded) 001, 002, ..., 366
      %m Code of month (zero-padded) 01, 02, ..., 12
      %M Minute (zero-padded) 00, 01, ..., 59
      %n Line break
      %p AM or PM (en_US) AM, PM
      %P am or pm (en_US) am, pm
      %r Alternative code of %I/%M/%S %p '01:49:23 AM'
      %R Alternative code of %H:%M '13:49'
      %S Second (zero-padded) 00, 01, ..., 59
      %t Tab
      %T Alternative code of %H:%M:%S '23:02:05'
      %u Code of day of week, where 1 stands for Monday ( or 1 for Sunday in a Sun Solaris system
      %U Week of year (zero-padded) with the first Sunday being the first day of the week 01 00, 01, ..., 53
      %V Week of year (zero-padded) with the first day till the first Sunday being week 01 if they have no less than 4 days, or being the last week of the previous year if less than 4 days 01, 02, ..., 53
      %W Week of year (zero-padded) with the first Monday being the first day of the week 01 00, 01, ..., 53
      %w Code of day of week, where 0 stands for Sunday 0, 1, ..., 6
      %x Default date format in the system settings '01/11/23'
      %X Default time format in the system settings '06:38:45'
      %y Alternative code of %g See example of %g
      %Y Alternative code of %G See example of %G
      %z UTC offset in the form ±HHMM[SS] +0000, -0400, +1030, ...
      %Z Time zone name GMT, UTC, IST, CST, ...
      %% Character % %

      Constant

      Example: Convert "2020-01-02 00:05:32" to 'yy-mm-dd hh:mm' format

      return dateFormat("2020-01-02 00:05:32", "%y-%m-%d %R")
      

      Function

      Example: Convert current system time to 'yyyy/mm/dd' format with AM/PM

      return dateFormat(now(), "%Y/%m/%d %r")
      

      Alias

      Example: Find 10 @trasnfer edges, return the time zone of the transfer time

      find().edges({@transfer}) as e
      limit 10
      return dateFormat(e.time, "%Ez")
      

      Property

      Example: Find 10 @transfer edges with their transfer time on weekend

      find().edges({dateFormat(@transfer.time, "%w") in [0, 6]}) as e
      limit 10
      return e{*} 
      
      Please complete the following information to download this book
      *
      公司名称不能为空
      *
      公司邮箱必须填写
      *
      你的名字必须填写
      *
      你的电话必须填写
      *
      你的电话必须填写