It's my birthday … 5th August. A at B in C on

Happy birthday! The correct preposition to use here is "on." So the sentence should be: "It's my birthday on 5th August." Enjoy your special day!