Subject | Including year in search of timestamp field |
---|---|
Author | bhata |
Post date | 2002-08-02T17:55:01Z |
I'm using CONTAINING to search any field in my table. On a TIMESTAMP
field I have determined how to search on almost everything except for
a date which includes the year.
For example if my field contains: 01/02/2003 14:05:06
I can search on:
Fields: 01, 02, 03, 2003, 14, 05, 06
Time: 14:05, 14:05:06, 05:06
M & D: 01-02
But I have not determined how to include the year. I have tried the
following without success:
01-02-03
01-02-2003
01-02-103
03-01-02
2003-01-02
103-01-02
Does anyone know of how to include the year for such a search?
Does someone the source available to see what format can be used?
Thanks
field I have determined how to search on almost everything except for
a date which includes the year.
For example if my field contains: 01/02/2003 14:05:06
I can search on:
Fields: 01, 02, 03, 2003, 14, 05, 06
Time: 14:05, 14:05:06, 05:06
M & D: 01-02
But I have not determined how to include the year. I have tried the
following without success:
01-02-03
01-02-2003
01-02-103
03-01-02
2003-01-02
103-01-02
Does anyone know of how to include the year for such a search?
Does someone the source available to see what format can be used?
Thanks