Neil Steventon wrote:
> Hi,
>
> I have a table with a filed called - DateEntered which has the default value
> of getdate().
> I woul however just like it to return the date in the format dd/mm/yyyy
> without the time, how do you do this as a default value.
>
> I ca query the table and convert but thought there must be a simple way to
> do this , anybody know?

"MGFoster" <me@privacy.com> wrote in message
news:bOLRd.977$873.706@newsread3.news.pas.earthlink.net...
> Neil Steventon wrote:
> > Hi,
> >
> > I have a table with a filed called - DateEntered which has the default
value
> > of getdate().
> > I woul however just like it to return the date in the format dd/mm/yyyy
> > without the time, how do you do this as a default value.
> >
> > I ca query the table and convert but thought there must be a simple way
to
> > do this , anybody know?
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> The result of the call to GETDATE() will be both the date & the time.
> If you just want the date value to be stored you can use the CONVERT()
> function like this:
>
> ... DEFAULT CONVERT(DATETIME, CONVERT(VARCHAR(10), GETDATE(),101))
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBQheJDYechKqOuFEgEQJhNwCfaGmZJA+vVzJOUoUoDVTTKkqFQ4kAoLtG
> j6bebg4dk1iETa+msZ2o5Tsg
> =KnG6
> -----END PGP SIGNATURE-----

On Sun, 20 Feb 2005 02:32:23 -0800, Neil Steventon wrote:

>Thank you ,
>
>That works great just what I wanted - I didnt think you could do it like
>this. I thought because it was a date field then I couldnt convert it in
>the default value to a varchar.