Hi! My date field is integer. I record the value returned by function time() (time.h). When i need to do some comparison, i use a function that i created in sqlite for use in my sql statements. This function works like strftime. I pass the time and the format (like "%m-%d-%y") and it returns a char with the date formatted. []'s Victor
Kurt Welgehausen <[EMAIL PROTECTED]> escreveu: > Already did. > It doesn't talk about date comparison. Dates are stored in SQLite as strings or numbers (your choice). Comparisons of dates are just comparisons of strings or numbers. There is no Date type. Regards "Só existem 10 tipos de pessoas, as que sabem e as que não sabem binário." __________________________________________________ Converse com seus amigos em tempo real com o Yahoo! Messenger http://br.download.yahoo.com/messenger/