time()

Read(2428) Label: time,

Here’s how to use time() functions.

time( datetimeExp )

Description:

Get the time part from the datetime value.

Syntax:  

time(datetimeExp)

Note:  

The function gets the time part from the datetime value datetimeExp. The result is accurate to millisecond by default. The format must be consistent with the time format in the configuration information. By default, the configure information will not be displayed in millisecond.

Parameter:  

datetimeExp

Datetime data

Option:

@m

Accurate to minute

@s

Accurate to second

Return value:

Time value

Example:

time(now())

16:28:26400

time@s(now())

16:28:260

time@m(now())

16:28:000

Related function:

date()

date(datetimeExp)

datetime(datetimeExp)

datetime()

time()

time()

Description:

Convert a string or integer to time data.

Syntax:

time(stringExp)

Convert string string into time value according to system-defined datetime format; return null if the conversion fails

time(stringExp{, format}:loc)

Convert the string stringExp to time data type according to the format specified by format and return null if the conversion fails. If there is no parameter format, format of stringExp must be in consistent with the time format in the configuration information. Parameter loc is the language used in stringExp; default is the system language

time(h,m,s)

Convert h,m,s of integer type to time data

Note:

The function converts the string stringExp or integers h,m,s to time data.

Parameter:

stringExp

A string

format

A string specifying data format

loc

Language name, which is case insensitive. The most commonly used languages are Chinese (zh) and English (en); see A.sort() to know other languages supported in esProc

h

Integer

m

Integer

s

Integer

Return value:

Time

Example:

time("00:00:45")

00:00:45

time("00/00/45","HH/mm/ss")

00:00:45

time(12,13,00)

12:13:00

time("1:08 PM","h:mm a":"en")

13:08:00

Related function:

datetime()

date()

date(datetimeExp)

datetime(datetimeExp)

time(datetimeExp)