When to tell firstborn he will be a big brother?

Jessica • I`m 31 yrs old with a 9 yr old son, and pregnant with baby #2
My son is 9 years old and I found out on Friday that I'm pregnant. I'm curious to know when others broke the news to their children and how they did it. And how...creative, funny, memorable?