One way would be to use integers to represent the months
1 = Jan, 2 = Feb ...
- Rami
On 27.9.2010 3:06, Clint Hyde wrote:
I have a table that is about months...names to be precise...which of
course have
ascii_name_order != date_time_order
that said, all my incoming info is about the month name.
so I'd like to create a custom sort/collation order for this one
column in this one table.
How do I do that?
-- clint
------
my db is close to going live for public consumption...I have ~ 1
million records in it, text indexing is working properly (yay! thanks!)
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
