RIAS
asked on
SQl query
Hello,
Need to write a query on table to mask values return.
Table1
Name EndDate
A 23-11-90
B 31-12-9999
C 12-10-2013
Diplay results:
Name EndDate
A 23-11-90
B
C 12-10-2013
Mask the max date
Cheers
Need to write a query on table to mask values return.
Table1
Name EndDate
A 23-11-90
B 31-12-9999
C 12-10-2013
Diplay results:
Name EndDate
A 23-11-90
B
C 12-10-2013
Mask the max date
Cheers
What kind of mask do you want to apply?
ASKER
Thanks. If the value is max date then display nothing
Diplay results:
Name EndDate
A 23-11-90
B
C 12-10-2013
Diplay results:
Name EndDate
A 23-11-90
B
C 12-10-2013
Ok, but you're presenting non date values as well (e.g. 23-11-90).
Is this a varchar column instead of a date column?
Is this a varchar column instead of a date column?
ASKER
I need to select all columns in the table. The column EndDate has max date in it. Need to display the value as blank when it is max date.
Thanks
Thanks
ASKER
nope , it is datetime column
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!