Hi guys, i have a little problem getting a 24hr format time into the server as datetime, is there any tips on getting it into the sql database?
for example i have to grab from a textfile, 0800 as time in and 1700 as time out and store them into the table. in the textfile i also have the date of the time in time out which belongs to the same day.
the format of the textfile is in
date|timein|timeout
i was able to retrieve the individual values, i just need to find out how to store them in sql server. thanks in advance.
for example i have to grab from a textfile, 0800 as time in and 1700 as time out and store them into the table. in the textfile i also have the date of the time in time out which belongs to the same day.
the format of the textfile is in
date|timein|timeout
i was able to retrieve the individual values, i just need to find out how to store them in sql server. thanks in advance.