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.
p931226Asked:
Who is Participating?
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.