Display only date and no time

Garima Bansal

Since the database field is a datetime datatype and I am converting the current date to string format, this is not working.. how can I do this? I am doing the string format because I want the date in mm/dd/yyyy format and not in mm/dd/yyyy hh:mm:ss time format..

i want show date like dd/mm/yyyy
but i dont why timestamp is showing like
dd/mm/yyyy 3:00 PM

Updated dt.

(item.linedeptdt != null)

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi2y ago
Accepted answer
Hello

you can try the below code to get expected result
```
Updated dt.


    @if(item.linedeptdt != null){
       @item.linedeptdt.Value.ToShortDateString()
    }
 
```
Thanks

Vishal Joshi
0
Mrunali Sawant2y ago
To display only the date part from a datetime field in dd/MM/yyyy format in ASP.NET, you can use the ToString method with a format string in your Razor view.
```
Updated dt.

    @if (item.linedeptdt != null)
    {
        @item.linedeptdt.Value.ToString("dd/MM/yyyy")
    }
```
+1
Amit Mohanty2y ago
If you prefer to handle the date formatting on the database side, you can use SQL queries to format the date before it is retrieved by your application.
```
SELECT 
    COLUMN_NAME,
    FORMAT(linedeptdt, 'dd/MM/yyyy') AS FormattedDate
FROM 
    YourTableName
```
+1
Mukesh Sagar2y ago
use this : SELECT CAST(GETDATE() AS date) AS DateOnly;
+1