Can I use wildcards with a TIMESTAMP attribute? If not, what is the
resulting format when I CAST it as VARCHAR? Now that I think about it, I
need the same questions answered for DATEs too.

Robert Stearns wrote:
[color=blue]
> Can I use wildcards with a TIMESTAMP attribute? If not, what is the
> resulting format when I CAST it as VARCHAR? Now that I think about it, I
> need the same questions answered for DATEs too.
>[/color]
Can you give an example? It's unclear what you mean to me.

Cheers
Serge

Serge Rielau wrote:[color=blue]
> Robert Stearns wrote:
>[color=green]
>> Can I use wildcards with a TIMESTAMP attribute? If not, what is the
>> resulting format when I CAST it as VARCHAR? Now that I think about it,
>> I need the same questions answered for DATEs too.
>>[/color]
> Can you give an example? It's unclear what you mean to me.
>
> Cheers
> Serge[/color]
Sure: everything in March of this year: like 2004-03%
every thing that ran on the first of any month: like ____-__-01%
anything done after 7PM before 7AM: like ____-__-__-19% or like
____-__-__-20% ... (Wouldn't a full regular expression accepting like be
nice?)

Robert,

CHAR(tstamp, ISO) LIKE '......' should do it.

Cheers
Serge

Robert Stearns wrote:
[color=blue]
> Serge Rielau wrote:
>[color=green]
>> Robert Stearns wrote:
>>[color=darkred]
>>> Can I use wildcards with a TIMESTAMP attribute? If not, what is the
>>> resulting format when I CAST it as VARCHAR? Now that I think about
>>> it, I need the same questions answered for DATEs too.
>>>[/color]
>> Can you give an example? It's unclear what you mean to me.
>>
>> Cheers
>> Serge[/color]
>
> Sure: everything in March of this year: like 2004-03%[/color]

You can't do where year(ts) = 2004 and month(ts) = 3?


Have you seen the YEAR, MONTH, DAY, HOUR ... functions that operate
on timestamps, dates and/or times?



-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----