Sandbox - 2017-03-30

« first day (2353 days earlier) ← previous day next day → last day (2581 days later) »

8:05 AM

4

A: is it safe to use 31 for "last day of the month" when comparing dates in MySQL

You can use the MySQL LAST_DAY() function for this: SELECT * FROM orders WHERE date >= '2015-02-01' AND date <= LAST_DAY('2015-02-01') (you probably also want >= and <= instead of excluding the first/last days of each month)

blah

4

A: is it safe to use 31 for "last day of the month" when comparing dates in MySQL

You can use the MySQL LAST_DAY() function for this: SELECT * FROM orders WHERE date >= '2015-02-01' AND date <= LAST_DAY('2015-02-01') (you probably also want >= and <= instead of excluding the first/last days of each month)

bakg

stackoverflow.com/questions/31678768

3 hours later…

10:58 AM

4

A: is it safe to use 31 for "last day of the month" when comparing dates in MySQL

You can use the MySQL LAST_DAY() function for this: SELECT * FROM orders WHERE date >= '2015-02-01' AND date <= LAST_DAY('2015-02-01') (you probably also want >= and <= instead of excluding the first/last days of each month)

11:15 AM

U NO TRUST?

@rene I just wanted to experience the glory for myself

———→→→––– weee

12:18 PM

Chat6502 started

@Chat6502 /h

@TuxCopter /hat6502 - Chatbot running on a MOS 6502 CPU

ROM reloaded

@Chat6502 /h

@TuxCopter /qChat6502 - Chatbot running on a MOS 6502 CPU

Hm, strange

12:20 PM

ROM reloaded

@Chat6502 $h

@TuxCopter $hat6502 - Chatbot running on a MOS 6502 CPU

hmm

ROM reloaded

Goodbye

Chat6502 started

Goodbye

Chat6502 started

Goodbye

o/

12:28 PM

Hi

Chat6502 started

@Chat6502 /h

@TuxCopter Zhat6502 - Chatbot running on a MOS 6502 CPU

weird

ROM reloaded

12:29 PM

@Chat6502 /h

@TuxCopter /hat6502 - Chatbot running on a MOS 6502 CPU

>_> I'm stupid

The code jumped to the wrong address

ROM reloaded

@Chat6502 /h

@TuxCopter Chat6502 - Chatbot running on a MOS 6502 CPU

:36385502 Chat6502 - Chatbot running on a MOS 6502 CPU

ROM reloaded

12:44 PM

@Chat6502 /h

@TuxCopter Unknown command

wut

oh

ROM reloaded

@Chat6502 /h

@TuxCopter Chat6502 - Chatbot running on a MOS 6502 CPU

ROM reloaded

12:46 PM

@Chat6502 @ Hm, that's kinda weird

oops I borked it

Goodbye

Chat6502 started

@Chat6502 @ test

@TuxCopter @ test

@Chat6502 Hi

@TuxCopter Hi

12:49 PM

No idea why it crashed

How does it run?

Are there browsers on the 6502?

MOS Technology 6502

The MOS Technology 6502 (typically "sixty-five-oh-two" or "six-five-oh-two") is an 8-bit microprocessor that was designed by a small team led by Chuck Peddle for MOS Technology. When it was introduced in 1975, the 6502 was, by a considerable margin, the least expensive full-featured microprocessor on the market. It initially sold for less than one-sixth the cost of competing designs from larger companies, such as Motorola and Intel, and caused rapid decreases in pricing across the entire processor market. Along with the Zilog Z80, it sparked a series of projects that resulted in the home computer...

The code of the chatbot is written in assembly for ^ (So no browsers possible lel)

Assembly, wow

And the crash came from the MMU

@KritixiLithos I find 6502 assembly kinda easier than x86 assembly

I've never done anything with assembly

12:53 PM

:36385694 Hi

@TuxCopter @ test

wtf

@TuxCopter @ Hm, that's kinda weird

@Chat6502 Hi

@TuxCopter Chat6502 - Chatbot running on a MOS 6502 CPU

@TuxCopter Chat6502 - Chatbot running on a MOS 6502 CPU

:36385644 Chat6502 - Chatbot running on a MOS 6502 CPU

what the hell is it doing

12:53 PM

@TuxCopter Chat6502 - Chatbot running on a MOS 6502 CPU

@TuxCopter @ Hm, that's kinda weird

@TuxCopter @ test

So you can connect to chat just by using assembly?

oh shet it broke

@TuxCopter Hi

@KritixiLithos Nah, the CPU+MMU is actually wrapped in a python program to connect it with SE

Hm it don't seem ratelimited

And the python is run where?

12:56 PM

@KritixiLithos The 6502 is emulated

Ah

So you don't have the actual microprocessor

No

But the emulator I use emulates it correctly except for the JMP bug

1:10 PM

oh pls

6502's indexed indirect addressing mode only works on zero page memory

Moment of truth

Chat6502 started

@Chat6502 H

@TuxCopter S

@Chat6502 A

@TuxCopter S

1:20 PM

@Chat6502 !

@TuxCopter S

hm

it should return a random letter

@Chat6502 S

@KritixiLithos SANDOM

@Chat6502 S

1:22 PM

:36386297

@Chat6502 s

@KritixiLithos S

@Chat6502 @Teth

@KritixiLithos @Chat6502 @Chat6502

@Chat6502 Teth

1:23 PM

:36386318

@Chat6502 DETH

@KritixiLithos SETH

Pointer arrays are total PITA in assembly >_>

@Chat6502 KITH

@TuxCopter SITH

@Chat6502 JNES

1:24 PM

@TuxCopter SNES

@Chat6502 .NES

@TuxCopter SNES

@Chat6502 LUCKS

...

No

>_>

Goodbye

1:26 PM

sorry

Just on SE chat everything gets flagged so

Chat6502 started

@Chat6502 Hey

:36386552

@Chat6502 What

1:31 PM

:36386560

hm

@Chat6502 Lorry

:36386586

I think the rng is borked

Goodbye

Chat6502 started

1:39 PM

oops I borked it

1 hour later…

2:57 PM

@Zalgo :(

2 hours later…

5:01 PM

wiki:Special:Random

:(

en.wikipedia.org/wiki/Special:Random

boo-urns!

cc @Unionhawk

2 hours later…

7:25 PM

testing testing

@Avery oh hey, self replies. How cool is that?

user image

scarily bad code at gist.github.com/ardaozkal/a97f1410c984d3980c0a3cde6bc0b0d1

(at least my bits)

« first day (2353 days earlier) ← previous day next day → last day (2581 days later) »

Transcript for

Mar '1730

Sandbox

Where you can play with chat features (except flagging) and ch...

ai bots chatgpt experimentation fishes oak sandbox

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2024 Stack Exchange Inc; legal

mobile