Mailing-List: list azipa@egroups.com; contact azipa-owner@egroups.com
OOOOh.
Well, it would actually use more resources than just storing the date and
the time--but if you really wanted to throw away the extra data for good you
could format the date before storing it. The formatted string could be
stored as character data, or even a number.
Of course, you would need to change the underlying table and the application
that puts data in it.
That's a lot of work just to discard precision, burn more CPU cycles, and
use more storage.
> -----Original Message-----
> From: George K Fahnbulleh [mailto:george.fahnbulleh@eformsystems.com]
> Sent: Friday, December 29, 2000 12:22 PM
> To: 'Trent Shipley'; 'Justin Wilson'; azipa@egroups.com
> Subject: RE: [azipa] SQL question
>
>
> Trent,
>
> He's actually trying to ''stamp'' the column with only the date. I don't
> believe that is possible in oracle or SQL. Regardless of what is in a
> date/time column, it can be read/displayed any way you wish.
>
> I believe he is really asking how to display only the date in a column, is
> that correct Justin?
>
> -----Original Message-----
> From: Trent Shipley [mailto:tshipley@symbio-tech.com]
> Sent: Friday, December 29, 2000 12:16 PM
> To: Justin Wilson; azipa@egroups.com
> Subject: RE: [azipa] SQL question
>
>
> That can be specific to the SQL implementation.
>
>
>
> In Oracle use the TO_CHAR() function.
>
> For example:
>
> SELECT TO_CHAR(some_date_column, "YYYY-MON-DD") FROM some_table
> /
>
> > -----Original Message-----
> > From: Justin Wilson [mailto:justin@labxpress.com]
> > Sent: Friday, December 29, 2000 12:17 PM
> > To: 'azipa@egroups.com'
> > Subject: [azipa] SQL question
> >
> >
> > I have a simple SQL question for anyone that knows SQL. I am
> > trying to time
> > date stamp entries that are made through one of our websites,
> Currently I
> > have it using date and time stamp. Is there a way to stamp these entries
> > with just the date?
> >
> > -Justin
> > justin@labxpress.com
> >
>
>
> ==AZIPA=============================================================
> Arizona Internet Professionals Association http://www.azipa.org
> Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
> Please be sure to RSVP! http://www.acteva.com/go/azipa
> Other upcoming events:
> Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
> Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
> Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
> http://www.srinstitute.com/cx326
> =============================================================AZIPA==
>
>
==AZIPA=============================================================
Arizona Internet Professionals Association http://www.azipa.org
Next AZIPA monthly meeting is 5:30pm on Monday, January 22nd, 2001
Please be sure to RSVP! http://www.acteva.com/go/azipa
Other upcoming events:
Tempe Tech Oasis Techie Tuesday - 6:00pm, Tuesday 1/9/01
Beeloe's Cafe & Bar, 501 S. Mill Ave Tempe (SE corner of 5th)
Strategic Research Institute Web Launch BootCamp - 1/30-2/2/01
http://www.srinstitute.com/cx326
=============================================================AZIPA==
