DOCUMENTATION CENTER SEARCH
DatabaseLink Paclet SymbolTutorials|See Also|More About

SQLDateTime

SQLDateTime[datetime]
represents date and time information that can be stored in a database.
EXAMPLESCLOSE ALL
Basic Examples   (1)
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 DatabaseExamples` package, as described in Using the Example Databases.
In[2]:=
Click for copyable input
This creates a table with data types DATE, DATETIME, and TIMESTAMP:
In[3]:=
Click for copyable input
This inserts the same data into each column:
In[4]:=
Click for copyable input
This selects the data as stored in the database:
In[5]:=
Click for copyable input
Out[5]=
This creates a table with data type TIME:
In[6]:=
Click for copyable input
This inserts time data:
In[7]:=
Click for copyable input
This selects the data:
In[8]:=
Click for copyable input
Out[8]=
In[9]:=
Click for copyable input
In[10]:=
Click for copyable input
In[11]:=
Click for copyable input
© 2008 Wolfram Research, Inc. japanese.gif