[GENERAL] About Date field

Hello, I use a simple table, in which i've a field of type date. Is is possible to insert the current date in this field, I mean using a special variable that has the systeme date. -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"

[GENERAL] Alter table possibility

I've just seen that alter allow to add a column But how can I do if I want to delete a column ? -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"

[GENERAL] Types available

Does anyone know which query (with system tables) could give me all the available type. Txs. -- Edouard DESSIOUX Proverbe chien : "Si ca se mange pas, Si ca se baise pas, Pisse dessus !!"

[GENERAL] How to select where ....

Hello, I've encountered a pb while making a simple request : A have a field date whose type is timestamp and I would like to make a select like : select * from truc where date > (current_timestamp - 10 days) Anyone know how I could perform such a query Txs -- Edouard DESSIOUX Prover