=Format(Now(), "MM/dd/yyyy hh:mm tt")
Output:
04/12/2013 05:09 PM
Full list of format options might be found here. Kudos to @MattGibson.
More Related Contents:
- divide by zero/null workaround in SSRS 2008 report
- Passing multiple values for a single parameter in Reporting Services
- Left Outer Join Not Working?
- Sql PIVOT and string concatenation aggregate
- how to remove time from datetime
- How to compare dates in datetime fields in Postgresql?
- is it possible to select EXISTS directly as a bit?
- What is the difference between a stored procedure and a view?
- Database Naming Conventions by Microsoft?
- Functions vs Stored Procedures
- What is the difference between cube, rollup and groupBy operators?
- How to get results in a custom order? [closed]
- How do NULL values affect performance in a database search?
- DB2 Query to retrieve all table names for a given schema
- How to perform a select query in a DO block?
- Is there any query for Cassandra as same as SQL:LIKE Condition?
- Cannot SELECT from UPDATE RETURNING clause in postgres
- Query for count of distinct values in a rolling date range
- Using CASE Statement inside IN Clause
- SQL Update woes in MS Access – Operation must use an updateable query
- SQL Convert Week Number to Date (dd/MM)
- How do I create a decimal field in Access with Alter Table?
- SQL Unpivot multiple columns Data
- Call stored procedure with table-valued parameter from java
- Concat function is not working – invalid number of arguments
- ORACLE After update trigger: solving ORA-04091 mutating table error
- Foreign Key Not Populating with Primary Key Values
- How to group by a Calculated Field
- SQL select * from column where year = 2010
- Oracle IN vs Exists difference?