Used for handling non-default style character-strings representing the date and time. This is predicated on handling date and time styles from different nations and/or languages.

learn more… | top users | synonyms

14
votes
2answers
12k views

How to set Postgresql database to see date as “MDY” permanently

How can I set my database to see the 'date' as "MDY" without running: SET datestyle = "ISO, MDY"; every-time I'm trying to access it? I'm using Postgresql version 9.1, Ubuntu 12.04. My system ...
4
votes
1answer
11k views

how to retrieve rows of different dates using IN clause

My table structure: +-----------------+--------------+------+-----+-------------------+----------------+ | Field | Type | Null | Key | Default | Extra | ...
2
votes
3answers
10k views

Date format in SSRS

I'm wondering if there is a setting in SSRS to indicate the date format. We need to show the dates in dd/mm/yyyy format on the reports and from what I can see in database the value has been stored ...