Concat help
Concat help
(OP)
I'm currently trying to make an easy script that will concatenate a date field and a time field so that I can sort by the Max of the date field. When I run the query I get a message saying that there are incompatible types in the expression. Can someone help a newbie out :) Thanks in advance.
My query is as follows: ($suffix, $wo, $seq are predefined by a form)
"SELECT concat(v_job_detail.date_last_chg, v_job_detail.time_last_chg)
FROM V_JOB_DETAIL
where V_job_detail.suffix='$suffix'
and v_job_detail.job='$wo'
and v_job_detail.seq='$seq'"
My query is as follows: ($suffix, $wo, $seq are predefined by a form)
"SELECT concat(v_job_detail.date_last_chg, v_job_detail.time_last_chg)
FROM V_JOB_DETAIL
where V_job_detail.suffix='$suffix'
and v_job_detail.job='$wo'
and v_job_detail.seq='$seq'"
RE: Concat help
"SELECT concat(CONVERT(v_job_detail.date_last_chg, SQL_CHAR), CONVERT(v_job_detail.time_last_chg,SQL_CHAR))
FROM V_JOB_DETAIL
where V_job_detail.suffix='$suffix'
and v_job_detail.job='$wo'
and v_job_detail.seq='$seq'"
Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com
RE: Concat help