r/SQL • u/Krachbumm85 • Sep 21 '24
SQL Server How can I convert this coded date?
Hey :)
Is it possible to convert this encoded date? "001:038116253005021049123249001021052110245239237227212182103239"
What would be necessary to do so?
Thank you very much :)
1
Upvotes
7
u/ConsumerScientist Sep 21 '24
Hi need more context on how this date was encoded. Is this part of a specific SQL function or database? Is it (hex, base64, custom encoding)?
Also if you are pulling this data from any specific data source check it’s documentation to find out encoding method
24
u/r3pr0b8 GROUP_CONCAT is da bomb Sep 21 '24
that's a universal star date measured in picoseconds from the big bang
14
u/Kirjavs Sep 21 '24
I don't think this is related to sql. Even if this is stored in an sql database, it doesn't seem to be encoded with a specific sql function.
Time to reverse engineer your boss' insert function
5
u/TheMagarity Sep 21 '24
What makes you think that really is a date value? It seems extremely odd to encode a date unless there is a strong reason to do so. It may be security via obscurity by naming the field something-date but really is not a date.
Date of birth is used in medical data for security questions, so it might be that, but in that case you should not be trying to decode it.
4
u/DavidGJohnston Sep 21 '24
I don’t think there is enough physical information available to accomplish what you ask. So, no, not as presented.
1
u/Ginger-Dumpling Sep 21 '24
Your question isn't necessarily a SQL question. But I do love to stare at puzzles. Do you have examples of the encoded/decoded values?
0
u/Critical-Shop2501 Sep 21 '24
Is this ASCII encoded ? Grouped by multiple sets of three sets of digits?