#JulianDay
LightNews LightNews
jkbecker.net
The Julian day calendar option? lol, yes very normal
SQL docs on the julianday() function
August 24, 2023 at 11:23 AM
bigrickystyle.bsky.social
Happy julianday!!
September 13, 2025 at 11:55 PM
bigrickystyle.bsky.social
Happy julianday!
September 14, 2024 at 1:27 PM
chuckbrouillette.bsky.social
#OnThisDay in 1958 #CalendarMan debuted in #DetectiveComics #259 #JulianDay #commitsCrimes in #GothamCity inspiredBy #The4Seasons laterDrops #5thSeason clue #Batman85 rightfully deduces as #MonsoonSeason #noFollowUpDateForMoreThanTwoDecadesTho @jamesgunn.bsky.social #littleBrother #SuicideSquadMovie
July 24, 2024 at 4:22 PM
chuckbrouillette.bsky.social
#OnThisDay in 1958 #CalendarMan debuted in @dc.com #DetectiveComics #259 #JulianDay #commitsCrimes in #GothamCity inspired by #The4Seasons drops #The5thSeason clue that #Batman deduces as #MonsoonSeason #noFollowUpDate #forMoreThanTwoDecades @jamesgunn.bsky.social #littleBrother #SuicideSquadMovie
July 24, 2025 at 3:02 PM
duan.ca
Unexpected usage of sqlite: to get a strict proleptic Gregorian calculation of seconds since unix epoch, use a query like `SELECT CAST(ROUND( (julianday(?) - 2440587.5) * 86400.0 ) AS INTEGER);` instead of Foundation's Date.
November 5, 2025 at 3:44 AM
debby.blue-ocean.social
It’s Julian day 2460666! 😱 Time for the end-time preachers to dust off their 'The End is Nigh' signs! But honestly, I think it’s just a great day to explore some interesting systems of keeping track of time!
😈😂
#EndTimes #EndOfDays #JulianDay #SatanicPanic #Calendars #JDN
December 22, 2024 at 1:38 AM
chuckbrouillette.bsky.social
#OnThisDay in 1958 #CalendarMan debuted in @dc.com #DetectiveComics #259 #JulianDay #commitsCrimes in #GothamCity inspiredBy #The4Seasons laterDrops #The5thSeason clue #Batman rightfully deduces as #MonsoonSeason noFollowUpDate4 #moreThan2decades @jamesgunn.bsky.social #littleBrother #SuicideSquadWB
July 24, 2026 at 2:50 PM
flozz.fr
Today on FLOZz Daily Mix, I am improving track rotation in the track selection algorithm:

If I listen to a song today, it reduces its chances to be picked for a playlist tomorrow. 😃️
SQL: « [...] + (LOG(1+MIN(JULIANDAY('now') - JULIANDAY(IFNULL(tracks.lastPlayed, JULIANDAY('1970-01-01'))), 30))) / LOG(30) / 4 -- rotation score [...] »
January 17, 2025 at 12:57 PM
flozz.mastodon.social.ap.brid.gy
Today on FLOZz Daily Mix, I am improving tracks rotation in the track selection algorithm:

If I listen to a music today, it reduce its chances to be picked for a playlist tomorrow. 😃️
SQL: « [...] + (LOG(1+MIN(JULIANDAY('now') - JULIANDAY(IFNULL(tracks.lastPlayed, JULIANDAY('1970-01-01'))), 30))) / LOG(30) / 4 -- rotation score [...] »
January 17, 2025 at 12:58 PM