![background image](http://html.mh-extra.com/html/sharp/zaurus-zr-5700/zaurus-zr-5700_operation-manual_371075351.webp)
88
Extracting information from date and time represen-
tations
There are six functions for extracting information from
date and time representations:
DAY(
date
)
Returns the value of the day in
date
,
which is an integer in the range 1 to
31.
Example: DAY(DATE(96,9,11))
returns 11. DAY(“9/11/96”) returns 11.
MONTH(
date
)
Returns the value of the month in
date
, which is an integer in the range
1 to 12.
Example: MONTH(DATE(96,9,11))
returns 9. MONTH(“9/11/96”) returns
9.
YEAR(
date
)
Returns the value of the year in
date
,
which is a 4-digit integer representing
the year.
Example: YEAR(DATE(96,9,11))
returns 1996. YEAER(“9/11/96”)
returns 1996.
HOUR(
time
)
Returns the value of the hour in
time
,
which is an integer in the range 0 to
23.
Example: HOUR(TIME(15,08,0))
returns 15. HOUR(“15:08:0”) returns
15.
MINUTE(
time
)
Returns the value of the minute in
time
, which is an integer in the range
0 to 59.
Example: MINUTE(TIME(15,08,0))
returns 8. MINUTE(“15:08:0”) returns
8.
SECOND(
time
)
Returns the value of the second in
time
, which is an integer in the range
0 to 59.
Example: SECOND(TIME(15,08,0))
returns 0. SECOND(“15:08:0”) returns
0.
Summary of Contents for Zaurus ZR-5700
Page 34: ...34 ...
Page 46: ...46 ...
Page 96: ...96 ...
Page 118: ...118 ...
Page 244: ...244 ...
Page 263: ...viii ...
Page 267: ...4 ...
Page 285: ...22 ...
Page 323: ...60 ...
Page 339: ...76 ...
Page 366: ...103 Communication Applications ...
Page 367: ...104 ...
Page 371: ...108 ...
Page 379: ...116 ...
Page 395: ...132 ...
Page 401: ...144 ...
Page 403: ...146 ...
Page 413: ...156 ...
Page 439: ...182 ...
Page 445: ...188 ...
Page 459: ...202 ...
Page 483: ...226 ...
Page 489: ...232 ...
Page 499: ...242 ...
Page 500: ...243 Terminal Introduction 245 Using Terminal 251 Troubleshooting 258 ...
Page 501: ...244 ...
Page 518: ...261 Index Spreadsheet 263 CompuServe 266 Pager Access 268 AT T Mail 270 Terminal 271 ...
Page 519: ...262 ...
Page 529: ...272 ...