Android Question DateTime

[Peekay]

How do I get the date and time (now) in the correct format for insertion into a datetime field in Sql Server?
Thanks
PK

 

[Erel]

If you are using jRDC2 then you should send the ticks value (Long).

 

[Peekay]

This code does not work: (can you please help):

Dim ThisDateTime As Long
DateTime.DateFormat="dd-MMM-yy HH:mm"
ThisDateTime = DateTime.TimeParse(DateTime.Now)
Dim cmd As DBcommand = CreateCommand("sendmessagefromsite",Array(ThisDateTime, AndroidID, Message))

java.text.ParseException: Unparseable date: "1594278402264"

 

[toby]

Dim cmd As DBcommand = CreateCommand("sendmessagefromsite",Array(DateTime.now, AndroidID, Message))

 

[eps]

As in Microsoft SQL Server?

How is the field defined in your DB?

 

[aeric]

DateTime.DateFormat = "yyyy-MM-dd"
DateTime.TimeFormat = "HH:mm:ss"                   
Dim ThisDateTime As Long = DateTime.Now

 

[Peekay]

As in Microsoft SQL Server?

How is the field defined in your DB?

Yes, MS Sql Server. It is defined as datetime

 

[aeric]

    DateTime.DateFormat = "yyyy-MM-dd"
    DateTime.TimeFormat = "HH:mm:ss"
    Dim ThisDateTime As Long = DateTime.Now
    Dim strDateTime As String = DateTime.Date(ThisDateTime) & " " & DateTime.Time(ThisDateTime)
    Log(strDateTime)

 

[Erel]

This code does not work: (can you please help):

You are not working with date / time values correctly.

I recommend you to watch the date & time video tutorial: https://www.b4x.com/etp.html

 

[Mahares]

Yes, MS Sql Server. It is defined as datetime

Dim ThisDateTime As String
    DateTime.DateFormat="yyyy-MM-dd HH:mm:ss"
    ThisDateTime = DateTime.date(DateTime.Now)
    Log(ThisDateTime)  'displays: 2020-07-09 07:36:24  of course current

 

[Peekay]

I think I have the datetime right. Thanks guys.