Skip to main content
N
NP_1057040712-Amethyst
12-Amethyst
December 20, 2023
Solved

createstampa2/modifystampa2/updatestampa2 date columns changed from 07-NOV-23 to 07-11-23

  • December 20, 2023
  • 1 reply
  • 1718 views

I am using Windchill PDMLink Release 12.1 and Datecode with CPS 12.1.2.0

createstampa2/modifystampa2/updatestampa2 date columns in epmdocumentmaster and epmdocument table used to be in the format DD-MON-YY (e.g. 07-NOV-23). Now, it got changed to format like e.g. 07-11-23. What could be the reason for this change?
Also, we are unable to query and fetch the data from these tables having this new date format.

Best answer by NP_10570407

Yes @HelesicPetr . You are right. I verified with my IT team, they have told there was a recent windows update which has resulted in this new date format.

Thanks to both of you for assisting with this question. 

1 reply

avillanueva
23-Emerald I
avillanueva23-Emerald I
23-Emerald I
December 20, 2023

This is certainly odd. How do you know it changed? Is it just the SQL browser that is rendering it differently? Does the Windchill UI still function? Is there a point in time it changed and does that correlate to any system or DB changes?

N
NP_1057040712-AmethystAuthor
12-Amethyst
December 21, 2023

Hi,

Last time (3 weeks back) when we last logged into DB session, it was in the format 07-NOV-23. Since then, we didn't touch the DB. Couple of our team members were using the Windchill at application level only. they were editing few of the ACL's and modified few OIR settings for few products. apart from that we didn't modified anything else.

 

Yesterday, when we logged into the DB to query few epmdocument records based on date range, the results are not fetched and when we investigated, it is in the 07-11-23.

Even when I try query database table with where clause createstampa2='07-11-23', no results are obtained. It is weird.

 

Request your help with this strange situation.

  

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
December 21, 2023

Hi @NP_10570407 

 

The values in database have not changed. The values in db are still same, your output is just different

There could be Windows system update, studio update or somene changed your windows setting to use different date format.

 

PS> if I select the date column my format is absolutly different then yours.

PetrH

 

    Terms & ConditionsAccessibility statement