Thread: Published date with day (and time) or only with month
View Single Post
Old 02-04-2021, 12:20 AM   #6
halloleo
Groupie
halloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameterhalloleo can solve quadratic equations while standing on his or her head reciting poetry in iambic pentameter
 
Posts: 156
Karma: 12649
Join Date: Feb 2020
Device: iPad
Quote:
Originally Posted by ownedbycats View Post
The full value is stored regardless of format (which is why you can copy/paste between datetime columns of unlike formats).
But what can I do when I do not know the day and time of the published date? How can I distinguish an unknown day and time from 01 00:00:00 (which seems to be the default fill-in).

Very often day and time of the published field are unkown, but setting this information to valid default values doesn't seem right to me, because then there is no way to tell the difference between a fully known 1 Jan 2020 as published date and just 2020 as the published date.
halloleo is offline   Reply With Quote