Formatting term column

[Brian Price]

Hi,

The sample for Q2 reads select * from q2(...) and returns a table of data with one column titled 'term'.

The values returned for 'term' are 10s1 and 12s2 in the sample.

Two questions:
1. What is the correct output for a year between 2000 and 2009 inclusive? is it 00s2 or 0s2?
2. The semester code - this should be lower case 's' not 'S' in the output?

Thanks

[Kai Wang]

1.00s2

2.Just check the sample output, it is 's'.

--
You received this message because you are subscribed to the Google Groups "COMP9311 Project Q&A" group.
To unsubscribe from this group and stop receiving emails from it, send an email to comp9311-projec...@googlegroups.com.
Visit this group at https://groups.google.com/group/comp9311-project-qa.
To view this discussion on the web visit https://groups.google.com/d/msgid/comp9311-project-qa/54fef752-bf2a-4929-93be-65238e206deb%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Sarah Kazemi]

Hi Kai,

I don't think that we should return 00s2 for a course which has been hold on for example 2008 semester 2.

I think that we should return 08s2?

Is that right?

regards,

Sarah

On Tuesday, May 1, 2018 at 11:01:03 PM UTC+10, Kai Wang wrote:

1.00s2

2.Just check the sample output, it is 's'.

On Tue, May 1, 2018, 22:50 Brian Price <brianpr...@gmail.com> wrote:

Hi,

The sample for Q2 reads select * from q2(...) and returns a table of data with one column titled 'term'.

The values returned for 'term' are 10s1 and 12s2 in the sample.

Two questions:
1. What is the correct output for a year between 2000 and 2009 inclusive? is it 00s2 or 0s2?
2. The semester code - this should be lower case 's' not 'S' in the output?

Thanks

--
You received this message because you are subscribed to the Google Groups "COMP9311 Project Q&A" group.

To unsubscribe from this group and stop receiving emails from it, send an email to comp9311-project-qa+unsub...@googlegroups.com.