Open topic with navigation

TIBCO ActiveSpaces® 4.8.0

# Result Column Examples

The date and time functions supported by ActiveSpaces can be used in the list of result columns for a SELECT statement. The date and time functions cannot be used with table iterators.

Given a table with the following columns and values for 2016-12-24 00:00:00:

Columns | Data Type | Values
--- | --- | ---
`dtm` | `datetime` | [1482566400, 0]
`dtmstr` | `string` | “2016-12-24T00:00:00”
`dtmlong` | `long` | 1482566400
`julianday` | `double` | 2457746.50000

The following are examples of SELECT statements that use the date and time functions in the select list of the SELECT statement:

    SELECT key, date(dtm) FROM mytable WHERE key<=10
    SELECT key, datetime(dtm) FROM mytable WHERE key<=10
    SELECT key, time(dtm) FROM mytable WHERE key<=10
    SELECT key, julianday(dtm) FROM mytable WHERE key<=10
    SELECT key, datetime(now), date(dtm) FROM mytable WHERE key <=10

Copyright © 2009-2022. Cloud Software Group, Inc. All Rights Reserved.