..nervermind, got it.<br><br>convert (varchar (10), [date_field], 120)<br><br>does that mean though that I stuck with one of the ~20 predefined date formats ??<br><br>edit : in at the same time ...

Dates Each system has its own format for retrieving the current date and time. Oracle does so as follows: SYSDATE SQL Server uses this approach: GETDATE () You can manipulate dates using different ...