Hi,
Thanks a lot.
It's working fine
Best Regards,
Madhumadhi.S
madhumadhi
Last Activity: Jun 5 '08, 07:55 AM
Joined: Jun 12 '07
Location:
-
DATEDIFF in Mysql 4.0
Dear All,
The following query is not working in Mysql 4.0
[CODE=mysql]SELECT DATEDIFF(
'2007-08-27', '2007-08-17'
) [/CODE]
But this query is working in MySQL 4.1.15.
What should i do to find the date difference in Mysql 4.0 But the date format query is working
ie
[CODE=mysql]SELECT DATE_FORMAT(Dt, '%d-%m-%Y') FROM Product_Master[/CODE].
Kindly provide the solution.... -
Dear All,
I have stored Product Names in the Table "Product Master". The Product names are like ' CS-142',' CS-143',' CS145' etc. If i search the 'CS142' , the record CS-142 should be fetched from the Product_Master table.
The query
"SELECT * FROM Product_Master WHERE Product_Name LIKE 'CS142%' ";
The above query is not fetching the records with the Poduct _Name CS-142....Leave a comment:
-
Like Concat
Dear All,
I have stored Product Name's in the Table "Product Master". The Product names are like ' CS-142',' CS-143',' CS145' etc. If i search the 'CS142' , the record CS-142 should be fetched from the Product_Master table. I need query to get these information.
Thanks in advance.
Regards,
Madhumadhi.S
No activity results to display
Leave a comment: