> My application will write XML to the database and I'm wondering if it is
> feasible to use a SQL2000 TIMESTAMP to record the lastBuildDate that
> indicates when an RSS channel was last edited.

clintonG wrote:
> My application will write XML to the database and I'm wondering if it is
> feasible to use a SQL2000 TIMESTAMP to record the lastBuildDate that
> indicates when an RSS channel was last edited. The RSS specifications [1]
> however require lastBuildDate to be formatted as: Sat, 07 Sep 2002 09:42:31
> GMT. I would need to convert the value of the TIMESTAMP when the XML stored
> in the database was retrieved. Comments?
>

"MGFoster" <me@privacy.com> wrote in message
news:gm%Ed.4669$pZ4.3864@newsread1.news.pas.earthlink.net...
> clintonG wrote:
> > My application will write XML to the database and I'm wondering if it is
> > feasible to use a SQL2000 TIMESTAMP to record the lastBuildDate that
> > indicates when an RSS channel was last edited. The RSS specifications
[1]
> > however require lastBuildDate to be formatted as: Sat, 07 Sep 2002
09:42:31
> > GMT. I would need to convert the value of the TIMESTAMP when the XML
stored
> > in the database was retrieved. Comments?
> >
>
> A Windows OS on a PC or server keeps system time in GMT. You can use
> the GetSystemTime API call in another programming language. See any
> websites, books about the GetSystemTime API call.
>
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)

"Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:udWYSXE%23EHA.608@TK2MSFTNGP15.phx.gbl...
> > My application will write XML to the database and I'm wondering if it is
> > feasible to use a SQL2000 TIMESTAMP to record the lastBuildDate that
> > indicates when an RSS channel was last edited.
>
> (a) TIMESTAMP has absolutely nothing to do with date or time. You cannot
> "convert" a TIMESTAMP value to anything meaningful to an end user, because
> no date or time components are encoded in the value (see now why
ROWVERSION
> is a better name for this datatype?) :-)
>
> (b) You can use DATETIME (or SMALLDATETIME if you don't care about
seconds),
> and you can easily convert to GMT as long as you know your offset (or can
> calculate it at runtime, or pre-populate a calendar table of some sort).
>
> Some information on (a) that might be useful:
> http://www.aspfaq.com/2448
>
> Some information on (b) that might be useful:
> http://www.aspfaq.com/2218
> http://www.aspfaq.com/2519
>
>