cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

storing datetime in datatable with 12 hours format.

AP_10343008
15-Moonstone

storing datetime in datatable with 12 hours format.

There is datetime field in datashape for storing dates in datatable. In datatable the datetime should be stored in 12 hours format without converting the datetime to string. How to do this ?

 

 

 

 

 

ACCEPTED SOLUTION

Accepted Solutions

Hi @AP_10343008 

 

I think it is not possible to store DateTime value in 12 hours format but while displaying you can convert it to 12 hours format and display it

 

Something like this

Velkumar_0-1683780539419.png

Actual value stored in DataTable

Velkumar_1-1683780571544.png

 

You need to specify DateTime format in Grid Column Renderer configuration (if you are going to display in Grid)

Velkumar_2-1683780688735.png

 

 

/VR

 

 

View solution in original post

2 REPLIES 2

Hi @AP_10343008 

 

I think it is not possible to store DateTime value in 12 hours format but while displaying you can convert it to 12 hours format and display it

 

Something like this

Velkumar_0-1683780539419.png

Actual value stored in DataTable

Velkumar_1-1683780571544.png

 

You need to specify DateTime format in Grid Column Renderer configuration (if you are going to display in Grid)

Velkumar_2-1683780688735.png

 

 

/VR

 

 

Hello @AP_10343008 

 

Kindly revert if you have any further queries on this thread or accpt the given solution by @Velkumar for the benefit of other community Users.

 

Have a good day ahead!

 

Regards

Bhawna

Announcements


Top Tags