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

DateTime.Parse() problem

Using
DateTime.Parse("15:00")
will pass Today's date + 15:00 into DB and become

21/09/2004 03:00:00 PM

=================

If I only want to pass the TIME (15:00) into db and become

03:00:00 PM

in the DB...

how can I parse?

Thanks.
0
p931226
Asked:
p931226
1 Solution
 
OlegPCommented:
convert to string and cut date

1) if result value is YourDateTimeValue datetime
substring(convert(varchar,YourDateTimeValue,100),12,8)

or
2)if result value YourDateTimeValue is varchar
substring(YourDateTimeValue,12,8)

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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