however, in my LINQPAD 4, I am able to retrieve the TIMESTAMP in MM/DD/YYYY hh:mm format, as below:
I would want my LINQPAD 4 TIMESTAMP to be the same format as the Microsoft Query, is that possible?
Display database timestamp in YYYY-MM-DD hh:mm:ss format
in my Microsoft Query, I have able to retrieve the data for the TIMESTAMP in YYYY-MM-DD hh:mm:ss format, as shown below:
however, in my LINQPAD 4, I am able to retrieve the TIMESTAMP in MM/DD/YYYY hh:mm format, as below:
I would want my LINQPAD 4 TIMESTAMP to be the same format as the Microsoft Query, is that possible?
however, in my LINQPAD 4, I am able to retrieve the TIMESTAMP in MM/DD/YYYY hh:mm format, as below:
I would want my LINQPAD 4 TIMESTAMP to be the same format as the Microsoft Query, is that possible?
Iftikar HussainPosted Aug 1, 2013, 1:59 AM
SELECT MAINSERNO, MONO, ITNO,
TO_CHAR (TIMESTAMP, 'YYYY-MM-DD HH:MI:SS') as DateTime
Regards,
Iftikar
TAN WhoAMIPosted Aug 1, 2013, 1:56 AM
Sanjeeb LenkaPosted Aug 1, 2013, 1:51 AM
SELECT MAINSERNO, MONO, ITNO,TO_TIMESTAMP(TIMESTAMP,'YYYY-MM-DD HH24:MI:SS') as TimeStamp
FROM PPL_PRODUCT_TESTID2
TAN WhoAMIPosted Aug 1, 2013, 1:48 AM
Iftikar HussainPosted Aug 1, 2013, 12:54 AM
Regards,
Iftikar
TAN WhoAMIPosted Aug 1, 2013, 12:50 AM
Iftikar HussainPosted Jul 31, 2013, 11:49 PM
Try like this
CONVERT(varchar(19),TIMESTAMP,120) as TimeStamp
Regards,
Iftikar