| T O P I C R E V I E W |
| pppoe5 |
Posted - 08/06/2023 : 11:05:47 PM
Origin Ver. and Service Release (Select Help-->About Origin): 9.9.0.225
Operating System:win10
I have a book with time col as:
2023/4/26 3:15:05.20
2023/4/26 3:15:05.80
2023/4/26 3:15:05.140
2023/4/26 3:15:05.200
2023/4/26 3:15:05.260
2023/4/26 3:15:05.320
2023/4/26 3:15:05.380
2023/4/26 3:15:05.440
How can I set their format? I try 'yyyy/m/dd h:mm:ss.###'
but not right!
Thanks for advance! |
| 4 L A T E S T R E P L I E S (Newest First) |
| pppoe5 |
Posted - 08/07/2023 : 09:39:49 AM
Many thanks!
But I have to chang them by hand .
You know it has a lot of records like this '.20', '.40' ... in my case. |
| ChaoC |
Posted - 08/07/2023 : 09:32:19 AM
Hello,
There isn't a millisecond format. The ### indicates fractional seconds so your date should be written as 2023/4/26 3:15:05.020 for 20ms.
https://www.originlab.com/doc/en/Origin-Help/WksCol-DateTime
Best,
Chao |
| pppoe5 |
Posted - 08/07/2023 : 09:14:45 AM
Thanks Chao!
But the format will change '2023/4/26 3:15:05.20' to '2023/4/26 3:15:05.200'.
The record means 20ms(millisecond).
So, any suggestion? |
| ChaoC |
Posted - 08/07/2023 : 08:57:40 AM
Hello,
You would need to set the column as Date and set the format to:
yyyy/M/dd h:mm:ss.###
M is for month
m is for minute
Best,
Chao |
