i have a date format as '8/17/2020 4:28:46 PM'
want date as 17-aug-2020
If I use format() function i get varchar not date
hi hope this helps
declare @var varchar(100) = '8/17/2020 4:28:46 PM' select CONVERT(nvarchar(30),cast(@var as date), 6)
would I be able to filter with this?
.. where convert(nvarchar(30),cast(@var as date),6)>='01-apr-2021'
Originally my value i posted is a date...so?
It's better to filter date using date
Date123 > cast(01-april-2021 as date )
Is this in a variable or column? SQL Server does not store dates in a string format - not sure what you are trying to resolve.
this is a value stored in a datetime column sir
Okay - you have a datetime column and you want it to display in a different format? Where do you want it to be displayed differently?
Again - that column is not stored with a format, it is stored as a numeric value.
Actually we crated a table from a csv file. Data is downloaded from some interface into excel.
of that excel we saved it in csv and using task>import data from flat file .. the table is created
Now we want to filter data based on date ..
I am trying to get data using 'where ' clause but filter is not being set and a few records slipped ...
I am confused and do not know how to tackle this issue
sure sir but not possibel today
my client is having off Today
we can join tomorrow if you can
On this imported table - what is the data type of the column containing this 'date'? If you did not set it up as a datetime data type that is the problem. If it is a datetime data type, then the question remains - where do you want to display the date in that specific format?
If you are running a query and 'some' of the data is not being returned - please provide that query so we can see where there might be a problem.
Ideally, you would use a where clause such as:
WHERE datecolumn >= '2020-08-17' --Aug 17th AND datecolumn < '2020-08-18' --implicitly converts to '2020-08-18 00:00:00.000' if datecolumn is a datetime data time