Q: Datetime in human readable form

[chuckyegg]

Hi guys

This feels like it should be really simple, but I can't get dates stored in TEXT fields in SQL into human readable form.

What I get is strings like "1350570465000"
What I want is "31/10/2012 13:59:01"

My SQL insert looks like this:

SQL1.ExecNonQuery("INSERT INTO Table VALUES('Name', '" & DateTime.DateParse(DateTime.Date(DateTime.Now)) & "'")

I have searched and looked at the guide, but I think it's too basic to have troubled most people!


TIA

 

[Mahares]

You cannot use the DateTime inside a SQL statement:

Dim MyDT, MyName as string
MyDT= DateTime.Date(DateTime.Now) & " " & DateTime.Time(DateTime.Now)
MyName="chuckyegg"
SQL1.ExecNonQuery2("INSERT INTO Table VALUES(?,? )" , Array as string (MyName,MyDT))

 

[chuckyegg]

Thanks, but I still get the long digits

This is my current code:

   DateTime.DateFormat = "dd/MM/yyyy HH:mm:ss"
   Dim strDateTime As String
   strDateTime = DateTime.DateParse(DateTime.Date(DateTime.Now))
   Log(strDateTime)

   datHubber.ExecNonQuery2("INSERT INTO MessageLog VALUES(?,?,?,?,?,?)" , Array As String (intMessageID, MobileNumber, strDateTime, Message, Direction, Status))

The Log() shows the numeric "date", the same as gets recorded in the table.

This is the code that creates the table:

   If datHubber.ExecQuerySingleResult("SELECT count(name) FROM sqlite_master WHERE type='table' AND name ='MessageLog'") = 0 Then
      datHubber.ExecNonQuery("CREATE TABLE MessageLog (MessageID INTEGER, MobileNumber TEXT, DateCreated TEXT, Message TEXT, Direction TEXT, Status TEXT)")
   End If

Any other ideas?

 

[Mahares]

DateTime.DateParse(DateTime.Date(DateTime.Now))

Should be:

DateTime.Date(DateTime.Now)

If you want to show both date and time, you can do this:

strDateTime=DateTime.Date(DateTime.Now) & " " & DateTime.Time(DateTime.Now)

 

[chuckyegg]

Aha! Working!
Thanks very much for your help