On 5/6/04 3:13 AM, "[EMAIL PROTECTED]"
<[EMAIL PROTECTED]> wrote:
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
you need to do is to get the select statement to convert the date to the
format you want and in MSSQL the function to do that is:
convert(varchar, <your date column>, <the format number>) and the format
number is an integer
I couldn't find the format you were after but try this
select convert(varchar, getdate(), 102)
Then change the "." for - and change the getdate() for your date column.
> From: "charalambos nicolaou" <[EMAIL PROTECTED]>
> Date: Thu, 06 May 2004 13:13:27 +0300
> To: [EMAIL PROTECTED]
> Subject: Insterting date in an MySQL table
> Hi everyone,
> I want to created a MYSQL table which will get the date in the form
> (YYYY-MM-DD) automatically. I have created the table below but it doesn’t
> get the form of date that I want. It has the form (YYYYMMDDHHMMSS)
> CREATE TABLE questions1 (ID INT NOT NULL AUTO_INCREMENT,name VARCHAR(30),day
> TIMESTAMP,question TEXT,email VARCHAR(30),answer TEXT, PRIMARY KEY(ID));
> Is there any other date field that gets the date form as I want?
> Thanks in advance
> Charalambos Nicolaou
Poet, Artist & Mystic
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php