WOLFRAM

Wolfram Language & System Documentation Center

SQLDateTime[datetime]

represents date and time information that can be stored in a database.

Details and Options
Details and Options Details and Options
Examples  
Basic Examples  
Generalizations & Extensions  
See Also
Tech Notes
Related Guides
DatabaseLink`
DatabaseLink`

SQLDateTime

SQLDateTime[datetime]

represents date and time information that can be stored in a database.

Details and Options

Examples

open all close all

Basic Examples  (1)

Wolfram Language code: Needs["DatabaseLink`"]

If you find that the examples in this section do not work as shown, you may need to install or restore the example database with the DatabaseLink`DatabaseExamples` package, as described in Using the Example Databases.

Open a connection:

Wolfram Language code: conn = OpenSQLConnection[JDBC["H2(Memory)", "sandbox"]];

This creates a table with data types DATE, DATETIME, and TIMESTAMP:

Wolfram Language code: SQLCreateTable[conn, SQLTable["DATETIMETABLE"], {SQLColumn["DATECOL", "DataTypeName" -> "DATE"], SQLColumn["DATETIMECOL", "DataTypeName" -> "DATETIME"], SQLColumn["TIMESTAMPCOL", "DataTypeName" -> "TIMESTAMP"]}]

This inserts the same data into each column:

Wolfram Language code: With[{d = SQLDateTime[DateList[]]}, SQLInsert[conn, "DATETIMETABLE", {"DATECOL", "DATETIMECOL", "TIMESTAMPCOL"}, {d, d, d}] ]

This selects the data as stored in the database:

Wolfram Language code: SQLSelect[conn, "DATETIMETABLE"]//First//Column

This creates a table with data type TIME:

Wolfram Language code: SQLCreateTable[conn, SQLTable["TIMETABLE"], {SQLColumn["TIMECOL", "DataTypeName" -> "TIME"]}]

This inserts time data:

Wolfram Language code: SQLInsert[conn, "TIMETABLE", {"TIMECOL"}, {SQLDateTime[Round[Take[DateList[], -3]]]}]

This selects the data:

Wolfram Language code: SQLSelect[conn, "TIMETABLE"]//First//Column
Wolfram Language code: SQLDropTable[conn, "TIMETABLE"];
Wolfram Language code: SQLDropTable[conn, "DATETIMETABLE"];
Wolfram Language code: CloseSQLConnection[conn];

Generalizations & Extensions  (1)

Wolfram Language code: Needs["DatabaseLink`"]
Wolfram Language code: conn = OpenSQLConnection[JDBC["H2(Memory)", "sandbox"]];

SQLDateTime expressions may be padded as necessary:

Wolfram Language code: SQLExecute[conn, "SELECT ?", {SQLDateTime[{2014, 2, 1}]}]
Wolfram Language code: SQLExecute[conn, "SELECT ?", {SQLDateTime[{0, 1, 2}]}]
Wolfram Language code: CloseSQLConnection[conn];