• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 340
  • Last Modified:

urgent: vb, convert a string to time format

hi all,

currently i have a string, for example: "20:18:54" , is it a way to convert it into time format/type, so that i can use/insert it into a database where the field is time format. how to write it in vb code? thanks!


mandy
0
mandydion
Asked:
mandydion
1 Solution
 
mladenoviczCommented:
If you use INSER INTO to add record to the DB then this string should be "#" & "20:18:54" & "#".
If you use recordset then just adoRecordset("TimeValue") = CDate("20:15:54")
0
 
morchubooCommented:
I struggled with the same problem for awhile - its due to the differing ways different microsoft produts handle dates/time
You dont need to convert the string at all - you just need to put in the sql statement correctly:

strsql = "INSERT INTO <table> (<name of field to contain the time>) VALUES ( #" & <variable containing time string> & "#)

Hope it helps
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now