How to extract a Date from an SQLDateTime object in Mathematica

Posted by andrews on Stack Overflow See other posts from Stack Overflow or by andrews
Published on 2010-03-18T15:52:56Z Indexed on 2010/03/18 16:21 UTC
Read the original article Hit count: 701

Filed under:

sqldatetime

|

mathematica

I am trying to do a plot of a time series with DateListPlot. I want to feed it a time series I obtain from an SQL database. When I retrieve the time series the list is composed of SQLDateTime entries that DateListPlot doesn't understand.

In[24]:= t=SQLExecute[conn, "select timestamp,value from timeseries order by timestamp asc"]

Out[24]={{SQLDateTime[{2010,1,1}],12.3},{SQLDateTime[{2010,1,2}],12.51}}

Doesn't work: In[25]:= DateListPlot[t]

DateListPlot requires a Date tuple and doesn't understand SQLDateTime. What can I do?

© Stack Overflow or respective owner

Related posts about sqldatetime

How to extract a Date from an SQLDateTime object in Mathematica

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to do a plot of a time series with DateListPlot. I want to feed it a time series I obtain from an SQL database. When I retrieve the time series the list is composed of SQLDateTime entries that DateListPlot doesn't understand. In[24]:= t=SQLExecute[conn, "select timestamp,value from… >>> More
SqlDateTime overflow on INSERT when date is correct using a Linq to SQL DataContext

as seen on Stack Overflow - Search for 'Stack Overflow'
Dear Linq experts, I get an SqlDateTime overflow error (Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.) when doing an INSERT using an Linq DataContext connected to SQL Server database when I do the SubmitChanges(). When I use the debugger the date value is correct. Even if I temporary… >>> More
NHibernate won't persist DateTime SqlDateTime overflow

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on an ASP.NET MVC project with NHibernate as the backend and am having some trouble getting some dates to write back to my SQL Server database tables. These date fields are NOT nullable, so the many answers here about how to setup nullable datetimes have not helped. Basically when I… >>> More
SqlDateTime overflow thrown by Typed DataSet Insert

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using a Typed DataSet with an Insert statement; I have a table that has a smalldatetime field defined to accept null values. When I insert from a .NET 2.0 FormView, I get a "SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM." Now, I've read this post, and… >>> More
SQLCLR and DateTime2

as seen on Stack Overflow - Search for 'Stack Overflow'
Using SQL Server 2008, Visual Studio 2005, .net 2.0 with SP2 (has support for new SQL Server 2008 data types). I'm trying to write an SQLCLR function that takes a DateTime2 as input and returns another DateTime2. e.g. : using System; using System.Data.SqlTypes; using Microsoft.SqlServer.Server; namespace… >>> More

Related posts about mathematica

Debugging a working program on Mathematica 5 with Mathematica 7

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everybody, I'm currently reading the Mathematica Guidebooks for Programming and I was trying to work out one of the very first program of the book. Basically, when I run the following program: Plot3D[{Re[Exp[1/(x + I y)]]}, {x, -0.02, 0.022}, {y, -0.04, 0.042}, PlotRange -> {-1, 8}, PlotPoints… >>> More
Mathematica 8 crashes Ubuntu 13.10

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have Mathematica 8 installed on my Ubuntu laptop since 2011. I updated Ubuntu several times, and experienced no problems with Mathematica. It also worked smoothly after I updated Ubuntu to 13.10 (it worked for sure for a week after update). When I tried to start Mathematica today by executing… >>> More
What is in your Mathematica tool bag?

as seen on Stack Overflow - Search for 'Stack Overflow'
We all know that Mathematica is great, but it also often lacks critical functionality. What kind of external packages / tools / resources do you use with Mathematica? I'll edit (and invite anyone else to do so too) this main post to include resources which are focused on general applicability in… >>> More
Running Mathematica-5 remotely

as seen on Server Fault - Search for 'Server Fault'
I have Mathematica 5 - a powerful CAS. I have a cheap netbook (running Windows XP), wich not only is too slow to run mathmatica on, I doubt it has the harddrive space. I do however have remote access to a number of very powerful computers, (most of wich run variose Linuxes, but one of which is Windows… >>> More
How to extract a Date from an SQLDateTime object in Mathematica

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to do a plot of a time series with DateListPlot. I want to feed it a time series I obtain from an SQL database. When I retrieve the time series the list is composed of SQLDateTime entries that DateListPlot doesn't understand. In[24]:= t=SQLExecute[conn, "select timestamp,value from… >>> More