On 5/6/04 3:13 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
Hi Charalambos,
In MSSQL as in most DBMS's the format the date is inserted, the format it is
stored and the format it is retrieved are quite independent.
If inserting the date is working (you are saving the correct date) then all
Maybe you can also use this syntax:
select date_format(now(), '%Y.%m.%d') name_of_the_column
Dalibor
charalambos nicolaou napsal(a):
Hi everyone,
I want to created a MYSQL table which will get the date in the form
(-MM-DD) automatically. I have created the table below but it
doesn?t get the fo
"Charalambos Nicolaou" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hi everyone,
>
> I want to created a MYSQL table which will get the date in the form
> (-MM-DD) automatically. I have created the table below but it doesnt
> get the form of date that I want. It has the form (