Question

How can I convert SQL time using a datetime stamp to milliseconds. I am doing a highstock chart using VB.Net

这是我迄今为止的甄选守则。

    Dim mydatalist As New List(Of XyData)
    Dim sqlReader As SqlDataReader
    Dim strConn As New     SqlConnection(ConfigurationManager.ConnectionStrings("myCipConnection").ConnectionString)
    Dim strSql As String = "SELECT TOP 1000 DATEDIFF(second,{d  1970-01-  01 },dtmStamp)AS dtmStamp  ,dblReturnTemp  FROM tblCIPEventData  "
    Dim sqlCmd As New SqlCommand(strSql, strConn)
    strConn.Open()
    sqlReader = sqlCmd.ExecuteReader

<><><>>I>有一套甄选<>/strong><>>>。

Dim strSql As String = "SELECT TOP 1 dtmStamp ,dblReturnTemp   FROM tblCIPEventData"

The result looks like

2009-10-22 11:29:31.513

<><>>>> 我怎么能将这种信息转换成微秒。

Answer 1

列出你最初必须与其他日期比较的日期的周期。减去两个日期之后,你将最后用一个时间点物体。然后,时间范围物体可转换为微秒。可以通过一条简单的法典来做到这一点:

Dim milliseconds As Double
milliseconds = (end - start).TotalMilliseconds

Answer 2

http://support.microsoft.com/kb/186265

You can use the SQL Server DATEPART() function to get the milliseconds of a SQL Server datetime field returned to a Visual Basic application.

例:

SELECT Pubdate, DATEPART(Ms, Pubdate) FROM Titles

Answer 3

就我们的工作而言,我们使用了时间序列,即时间周期,我们做了以下工作:

CONVERT(BIGINT, DATEDIFF(s,  19700101 , left(a.mdate, 11)))*1000

The left(a.mdate, 11) gives data like = Apr 25 2012 (in readable format)

a.mdate = 2012-04-25 11:01:18.030

这是在规定的时间内。

Answer 4

如果你想这样做,你只能。罗伯特·哈维的回答

If you want to it in VB.NET and you have the following

Dim strSql As String = "SELECT TOP 1 dtmStamp ,dblReturnTemp   FROM tblCIPEventData"

The result will be a System.DateTime

回答问题 我怎么能将这种转变转化为微秒? 我们可以使用

Dim dtmStamp as DateTime dtmStamp = sqlReader.GetDateTime(0) Dim ts As New TimeSpan(dtmStamp.Ticks) Dim milliseconds as Long milliseconds = TotalMilliseconds

这将使你们能够看到自此以来的千年大会的数目。页: 1

如果你想把这个时代 be到1970年1月1日,你就是这样做的。

Dim epoch as DateTime = new DateTime(1970,1,1) Dim ts As New TimeSpan((dtmStamp - epoch).Ticks)

Answer 5

这是我的工作:

me.labelDisplay.Text = CDate(query.dateColumn).ToString("yyyy-MM-dd HH:mm:ss.fff")

产出:

2017-03-23 16:35:08.237

如果你想得到微秒部分的使用:

Dim ms as Integer = CDate(query.dateColumn).Milliseconds()

友情链接