Is it possible to format date or date/time in SOQL query, like in SQL query?

SQL example: DATE_FORMAT(date, '%d.%m.%y %H:%i ')

How do I make a SOQL query from a custom object data using apex ?

I have custom object named News and I want to get all the added news a webpage.

This probably very simple to do, but I just couldn't find any examples or advise how to do this.

How do I login to customer portal from a VF login page?

I created a login page which uses the default login component, but couldn't find information anywhere how to login straight to customer portal using VF login component.

Is it possible to format date or date/time in SOQL query, like in SQL query?

SQL example: DATE_FORMAT(date, '%d.%m.%y %H:%i ')

How do I make a SOQL query from a custom object data using apex ?

I have custom object named News and I want to get all the added news a webpage.

This probably very simple to do, but I just couldn't find any examples or advise how to do this.

How do I login to customer portal from a VF login page?

I created a login page which uses the default login component, but couldn't find information anywhere how to login straight to customer portal using VF login component.