Suljettu

posrgresql sort by date

i have a database like this

id name day month year_id

day can be: 1 to 31

month can be: 1 to 12

year_id:

1 == 2014

2 == 2015

...

i need order by command to sort by date.

Taidot: PostgreSQL

Näytä lisää: sort sort sort, sort sort, 2015, date day, need simple customer database, need website searchable database option, sort date, vbnet datagrid date sort, need hotel booking database samplesa, datagrid date sort, need build online database, need complete project database management system hospital, date sort posts wordpress sort, need develop membership database web

Tietoa työnantajasta:
( 219 arvostelua ) Steyr Gleink, Austria

Projektin tunnus: #6141451

11 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

AlexYes

you can easily specify several columns in order by clause: order by year_id, month, day when the year is the same for several records, it stats sorting by month, the same for month and day, so finally you get you Lisää

$10 USD 1 päivässä
(2 arvostelua)
3.6
acronymsolutions

Hi, I have gone through your requirements and attachment as well.I am a DBA at CMM5 Level company since August 2010.I am working on PostgreSQL, MySql,SQL Server,Oracle database, I can do your job confidently. I am very Lisää

$34 USD 1 päivässä
(1 arvostelu)
3.5
magrirocks

Hello Sir, Please give us a chance. I have studied your project requirement I can do this project easily. I have done this type of work many time. I have done allot of work in Word-Press please check out my links. Lisää

$64 USD 1 päivässä
(1 arvostelu)
2.0
Koniii

Hallo. Ich durfte schon einmal einen Auftrag für Sie erledigen und würde auch diesen gerne mache. Wie soll die Sortierung aussehen? Aufsteigend nach Tag, Monat Jahr?

$15 USD 1 päivässä
(1 arvostelu)
0.0
robixxu

Hello! If you want i can help you with your postgresql query.. Just let me know how the sort should be ASC or DESC. I also can work in teamviewer..if you want. (80% completion is because i took a project, i finis Lisää

$18 USD 1 päivässä
(0 arvostelua)
0.0
sumshu

Hi, I have extensive experience in PostgreSQL development and Database Administration. I have the solution ready with me and can provide you the command (SQL query) right away. Thanks & Regards, Sumeet Shukl Lisää

$10 USD 0 päivässä
(0 arvostelua)
0.0
iticus

Hello, You will have to use something like: SELECT <fields you want here> FROM <table_name> WHERE <conditions you want here> ORDER BY year_id, month, day If you want to sort in descending order by date you have Lisää

$10 USD 0 päivässä
(0 arvostelua)
0.0
zeoinf

I have the solution ready for you! What also say? Minimum budget and 100% succes (sorry, system forced me to write at lease 100 chars) Regards, Luca.

$10 USD 1 päivässä
(0 arvostelua)
0.0
swaminath35

hi, i will do your need very good and worked under in postgresql for 3 years. i will serve u what ever type of query commands you have need thank you with regards Swaminathan .T

$10 USD 1 päivässä
(0 arvostelua)
0.0
lightweightcoder

Hi, I can complete this task.. Just one information needed. What are the data type of the day,month and year column ? is the day save as 1 or 01? Thanks

$10 USD 1 päivässä
(0 arvostelua)
0.0
wokdev

Hello, I have already written the query. Can send you right away. Looking forward to hearing back from you. Cheers Ashish

$10 USD 1 päivässä
(0 arvostelua)
0.0