Click here to Skip to main content
14,880,122 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
hi all,

i am getting 'time data' from One of my Db table time column like this '08:52:04.8500000'

How can i make it to only hh:mm:ss in rdlc report column

i already applied format column as hh:mm:ss , but it is showing like '08:52:04.8500000' only..


how can i get out of this ?




Thanks Advance
Posted

1 solution

try this
open report --> right click on Filed Name you will find expression

In Expression write

=TimeValue(Fields!BirthDate.Value)

BirthDate == FieldsValue/Column Name
   
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900