yyy hh:mm:ss) using SQL

paulrajm...

SOLVED CLOSED ACTIVE ANSWERED
User: paulrajmca
Posted: on Jun 06, 2016 10:46 PM
Forum: SQL Server
Answer: 1
Views: 3054

In my project i need to search records by date. that is from DateTime to to DateTime.my i am create the DateTime in Varchar format. now i Search records using from and to DateTimeit is not show exact output. i thing my created date format is wrong and that is the reason. So i want to convert from date and to date from varchar datatype to DateTimeFormat. and also which format will be give exact output for me is very important.

So please help me to how i am Convert already created data type Varchar to DateTime format or may i drop the column and recreate a new column with DateTime Format.

i am having lot of stress with this module friends.

Thanks with Paul.S

Download FREE API for Word, Excel and PDF in ASP.Net

dharmend...

0 4

Reply
ANSWER
User: dharmendr
Replied: on Jun 13, 2016 05:05 AM
Modified: on Jun 13, 2016 05:05 AM
Report

Refer the below query.

DECLARE @DateTime VARCHAR(50)
SET @DateTime = '2015/12/31 10:30:42'
SELECT CONVERT(VARCHAR,CAST(@DateTime AS DATETIME),103)+ ' ' + CONVERT(VARCHAR,CAST(@DateTime AS DATETIME),108) AS DATE

OutPut

31/12/2015 10:30:42

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to convert date Varchar Format to Date Format(dd/mm/yyy hh:mm:ss) using SQL

Company

Explore

Follow us

Contact Us