DATE TIME DATETIME in MYSQL

[georgepatotk]

i am having a DATE field and a TIME field.

For comparison purposes, i need to combine DATE and TIME into DATETIME.
Can anyone show me how? thanks.

I want something like

SELECT RCDATE & RCTIME FROM tblRC

where RCDATE & RCTIME equavalant to DATE field and TIME field.

 

[kejpa]

SELECT RCDATE , RCTIME, concat(RCDATE , ,RCTIME) FROM tblRC

works for me!

/Kejpa

 

[georgepatotk]

Wao this is great.

But, my problem is not solved yet.

SELECT s.SalesPK, s.SalesDate, s.SalesTime, s.TableName
FROM tblSales s

WHERE s.SalesPK <> 0

AND CONCAT(SalesDate,  , SalesTime) >= 2005-11-11 01:00:00
AND CONCAT(SalesDate,  , SalesTime) <= 2005-11-11 14:00:00
ORDER BY s.SalesPK ASC

I wanna show records withon the date duration. but, it doesnt work.
Or I should say, sometimes works, sometimes no...

Help me to figure this out. Thanks...

 

[georgepatotk]

Yeah, I figure out the problem,

SELECT s.SalesPK, s.SalesDate, s.SalesTime, s.TableName
FROM tblSales s

WHERE s.SalesPK <> 0

AND CONCAT(SalesDate,  , SalesTime) >= 2005-11-11 01:00:00
AND CONCAT(SalesDate,  , SalesTime) <= 2005-11-11 14:00:00
ORDER BY s.SalesPK ASC

This query is working, just I had passed wrong input to the command.
Anyway, Thanks...

 

[kejpa]

Why not use BETWEEN key word?

SELECT s.SalesPK, s.SalesDate, s.SalesTime, s.TableName
FROM tblSales s

WHERE s.SalesPK <> 0

AND CONCAT(SalesDate,  , SalesTime) between 2005-11-11 01:00:00
AND  2005-11-11 14:00:00
ORDER BY s.SalesPK ASC

/Kejpa

 

[georgepatotk]

For such a long time I had been using SQL query, I had never used Between in my program. How stupid am I?

Thanks for your suggestion. You really do me a big favor. And tell me something that is so useful for my future programs. Thanks again for pointing me the BETWEEN.