SQL Queries..

To check the database creation date and time:
Select name,crdate from master..sysdatabases
Procedure to Split data from one column into multiple column based on special characters:

declare @String varchar(MAX)

set @String = '100,200,250,300,350,450,500'
set @String =','+ @String + ','
SELECT REPLACE(Val_Column,',','')
FROM
(
select
substring(@String,number,CHARINDEX(',',@String,number+1)-number) As Val_Column
from
master..spt_values
where number < LEN(@String)
and type = 'P'
) C
where Val_Column like ',%'

To Split Full Name into First Name, Middle Name, Last Name in SQL Server using PARSENAME function:
DECLARE @SQLVariable VARCHAR(100);
SET @SQLVariable = 'Ashok.Raja.Velu Pillai.SQL Server';
select PARSENAME(@SQLVariable,1) AS Technical_Skill;
select PARSENAME(@SQLVariable,2) AS LAST_NAME;
select PARSENAME(@SQLVariable,3) AS MIDDLE_NAME;
select PARSENAME(@SQLVariable,4) AS FIRST_NAME;