TomBarrand
Programmer
What is the syntax that I need to put in the Formula property of a datetime data type so that the dates are stored in the format dd/mm/yyyy?
Thanks,
Thanks,
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Formula for a DateTime data type
- Thread starter TomBarrand
- Start date
- Status
In SQL Server dates are not held in diffrent formats. If you want the date returned in dd/mm/yyyy format use the following conversion function:
select convert(varchar(10),Col_1,103)
Where Col_1 is the column name on the table where the date is held.
Rick.
select convert(varchar(10),Col_1,103)
Where Col_1 is the column name on the table where the date is held.
Rick.
- Status
Similar threads
- Locked
- Question
- Locked
- Question