worldatlas
MIS
I have a field with an original datatype as HMDYYSA; however, I change in the master file into format HYYMD. However,
when I query this field using WHERE START_TIME_DATE EQ 20051004. It doesn't grab all the record because there are
other records that have the following data: 2005/10/04 01:00:00 AM or 2005/10/04 03:00:00 AM. Therefore, even though I change the format to YYMD in the master file, it doesn't grab these other records with hours in it. Is there anything I can do to code so I can pick all of these dates
Thanks in advance!
when I query this field using WHERE START_TIME_DATE EQ 20051004. It doesn't grab all the record because there are
other records that have the following data: 2005/10/04 01:00:00 AM or 2005/10/04 03:00:00 AM. Therefore, even though I change the format to YYMD in the master file, it doesn't grab these other records with hours in it. Is there anything I can do to code so I can pick all of these dates
Thanks in advance!