[Iudex]

How can I format the todays date to fit into a SQL date field? The format is 0000-00-00 00:00:00

Another question: When the field is filled out, can I then write only the date and not the time on my website without using for example left(date,11)?

i have found that using now() works if you want to code it using asp and the database accepts more than one format but displays it in only one it seems.

if you only want to store the date, there should be a date format (i might be mixing it up with one of the other dbases i work with) but try CDate()

[Iudex]

Yes! NOW() worked nicely!

And I found out my second question;
SELECT DATE_FORMAT(columnName,'%d/%m/%Y') FROM tableName

Now I can store both date and time(just in case), and still filter out what I want as output.

Google for sure is my friend...