In a query, Display the month in a Date field as text

[JohnB47]

I’m learning Base and I’m wondering how to do this. I have a table (called tblSpend) with a Date field (Field Type DATE[ DATE ]) and when I call this field up in a query it displays results like 12/06/23. If I use MONTH( [tblSpend].[Date] ) in the field name in the query, this produces a number, like 06 for June.

The SQL that produces a number is this:

SELECT “SpendID”, MONTH( “tblSpend”.“Date” ) FROM “tblSpend”

Is there code I can put in the field name position in the query to produce the result as text, rather than a number? i.e. in this example, I want to produce the result June, rather than 06. Or what change could I make to the SQL above to achieve this?

Thanks.

[cpb]

if you are using the default database, ‘HSQLDB embedded’ then you have great choice.
not all databases support all of these functions.

select
	"SpendID",
	"Date",
	month("Date") "Month",
	monthname("Date") "MonthName",
	to_char("Date", 'MON') "To_Char_MON",
	to_char("Date", 'MONTH') "To_Char_MONTH",
	to_char("Date", 'DD MON YY') "To_Char_DD MON YY",
	to_char("Date", 'DD MONTH YYYY') "To_Char_DD MONTH YYYY"
from "tblSpend"

[JohnB47]

Thank you so much. I’ve tried all of those and they work well for me - so much choice! Thanks also for the quick response.