MobileRead Forums - View Single Post - Dates

BetterRed · 10-08-2014, 07:58 PM

This has long puzzled me, I was reminded of it by this ==>> How to format pubdate...

The attached screen shot overlays a csv catalogue on the calibre book list for a single book.

The Published and My Published columns are both formatted as 'yyyy MM dd', they were entered into the book list within a second of two of one another, both were entered as '2015 01 01' (without use of the calendar gadget).

So my questions are

Why do they have different internal representations.
And what does my local offset from UTC time have to do with the published date - currently +11, a week ago it was +10. Sydney's small beer when it comes to book publishing

BR

10-08-2014, 07:58 PM	#1
BetterRed null operator (he/him) Posts: 21,638 Karma: 29710510 Join Date: Mar 2012 Location: Sydney Australia Device: none	Dates - Appear held to be inconsistent This has long puzzled me, I was reminded of it by this ==>> How to format pubdate... The attached screen shot overlays a csv catalogue on the calibre book list for a single book. The Published and My Published columns are both formatted as 'yyyy MM dd', they were entered into the book list within a second of two of one another, both were entered as '2015 01 01' (without use of the calendar gadget). So my questions are Why do they have different internal representations. And what does my local offset from UTC time have to do with the published date - currently +11, a week ago it was +10. Sydney's small beer when it comes to book publishing BR Attached Thumbnails