Extended Systems OneBridge 4.1 Guide de l'utilisateur télécharger pdf (Page 155)

APPENDIX A Function Reference

User’s Guide 141

uDateTime

Description Returns year, month, and day from a date in the format YYYY-MM-DD

HH:MM:SS.

Note Please refer to the “Working with Dates and Times” section for detailed

information about the possible modifier arguments.

Syntax string uDateTime([modifiers])

Parameters

string modifiers (optional)

String specifying a date or date calculation. The default is the

now modifier.

Examples To get the datetime part out of a timestamp.

uDateTime("now") // returns current date in the form

"YYYY-MM-DD HH:MM:SS"

uDateTime("now", "start of month", "1 months", "-1 day")

// returns the date of the last day in this month

uDay

Description Returns the day number of the date specified.

Note Refer to the “Working with Dates and Times” section for detailed

information about the possible modifier arguments.

Syntax string uDay([modifiers])

Parameters

string modifiers (optional)

String specifying a date or date calculation. The default is the

now modifier.

Examples To get the day number out of a timestamp:

uDay("now") // returns current day number

uDay("1969-03-13 10:22:23.231") // returns "13"

1 2 ... 150 151 152 153 154 155 156 157 158 159 160 ... 221 222

Pas de commentaire

Extended Systems OneBridge 4.1 Guide de l'utilisateur Page 155