[Help]Time format

[banktakung]

how to convert time 20150331031428 to normal datetime with php code sir.

[xTwiLightx]

In PHP, substr() is your weapon of choice:

PHP Code:

$rawtime = '20150331031428'; // unconverted datetime string

$year = substr($rawtime, 0, 4);
$month = substr($rawtime, 4, 2);
$day = substr($rawtime, 6, 2);
$hour = substr($rawtime, 8, 2);
$minute = substr($rawtime, 10, 2);
$second = substr($rawtime, 12, 2);

// stick them all together to get your datetime format
$datetime = "$year-$month-$day $hour:$minute:$second.000"; // .000 is optional. 


But you can do it much more easy when you use SQL functions:

CREATE function [dbo].[getdatetime]
( 
	@s_date	varchar(14)
)  
returns varchar(19)
as

begin

declare @c_date varchar(19)

	select @c_date =	convert(varchar(19),
							substring(@s_date,1,4) + '-' +
							substring(@s_date,5,2) + '-' +
							substring(@s_date,7,2) + ' ' +
							substring(@s_date,9,2) + ':' +
							substring(@s_date,11,2) + ':' +
							CASE substring(@s_date,13,2) WHEN '' THEN '00' ELSE substring(@s_date,13,2) END
						)
	return @c_date 
end

You can get the actual datetime like that:

select dbo.getdatetime('20150331031428') as convdate

So, if you are getting logs from LOGGING_01_DBF, you can do it like this:

This is my latest item log with (unconverted) s_date column.



Rewrite the query to use the function.




Easily done.

[banktakung]

Originally Posted by xTwiLightx

In PHP, substr() is your weapon of choice:

PHP Code:

$rawtime = '20150331031428'; // unconverted datetime string

$year = substr($rawtime, 0, 4);
$month = substr($rawtime, 4, 2);
$day = substr($rawtime, 6, 2);
$hour = substr($rawtime, 8, 2);
$minute = substr($rawtime, 10, 2);
$second = substr($rawtime, 12, 2);

// stick them all together to get your datetime format
$datetime = "$year-$month-$day $hour:$minute:$second.000"; // .000 is optional. 


But you can do it much more easy when you use SQL functions:

CREATE function [dbo].[getdatetime]
( 
	@s_date	varchar(14)
)  
returns varchar(19)
as

begin

declare @c_date varchar(19)

	select @c_date =	convert(varchar(19),
							substring(@s_date,1,4) + '-' +
							substring(@s_date,5,2) + '-' +
							substring(@s_date,7,2) + ' ' +
							substring(@s_date,9,2) + ':' +
							substring(@s_date,11,2) + ':' +
							CASE substring(@s_date,13,2) WHEN '' THEN '00' ELSE substring(@s_date,13,2) END
						)
	return @c_date 
end

You can get the actual datetime like that:

select dbo.getdatetime('20150331031428') as convdate

So, if you are getting logs from LOGGING_01_DBF, you can do it like this:

This is my latest item log with (unconverted) s_date column.



Rewrite the query to use the function.




Easily done.

Thank you so much