SQLite Date format

Solar2D Widgets
1

I am using SQLite and want to show the day of the month in a number format.  I need to use the current day.  I was trying to sysdate and get the day of the month from that, but that is not working.  Here is what I was trying: SUBSTR(sysdate,1,2)

Anyone have any ideas?

Thank you very much for your time.

2

Try using strftime(’%d’,‘now’)

3

Can you please explain what the ‘now’ modifier is doing in this case.  I stumbled on this while looking in the SQLite.org site, but got it working without the modifier.  I will put it in if it will eliminate errors or other problems that might arise, but I would like to know what those might be if you can.

THANKS A MILLION!!!

4

I believe ‘now’ is the timestring not the modifier. It is providing the current day/time input to the strftime function. See following site for some good insight and examples.

http://www.tutorialspoint.com/sqlite/sqlite_date_time.htm

5

Thanks for the help!  It works great!

6

Try using strftime(’%d’,‘now’)

7

Can you please explain what the ‘now’ modifier is doing in this case.  I stumbled on this while looking in the SQLite.org site, but got it working without the modifier.  I will put it in if it will eliminate errors or other problems that might arise, but I would like to know what those might be if you can.

THANKS A MILLION!!!

8

I believe ‘now’ is the timestring not the modifier. It is providing the current day/time input to the strftime function. See following site for some good insight and examples.

http://www.tutorialspoint.com/sqlite/sqlite_date_time.htm

9

Thanks for the help!  It works great!