Hi,
I am using the day() function to select the day of the week, is it possible to format the day so that it has a leading zero for days 1-9?
Thnaks in advance,
Rob.
Day with leading 0
Moderator: General Moderators
-
spacebiscuit
- Forum Contributor
- Posts: 390
- Joined: Mon Mar 07, 2005 3:20 pm
Thanks for the reply, I am not sure that will work in my case, here is the syntax i am using:
Can it be done?
Thanks,
Rob.
Code: Select all
select *, day(period_start_date) d1, left(month(period_start_date)....Thanks,
Rob.
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm